i'm struggling with an excel formula:
NEED: I need a formula to sum every 5 rows AND place the value on the respective row. (see table below)
Here's what i have so far but it isn't quite there:
=SUM(OFFSET($A$2,(ROW()-ROW($B$2))*5,,5,))
| A | B | C
-----------------------
1 | 5 | 37 | 37
2 | 10 | 24 | 37
3 | 7 | 17 | 37
4 | 7 | 0 | 37
5 | 8 | 0 | 37
6 | 1 | 0 | 24
7 | 3 | 0 | 24
8 | 5 | 0 | 24
9 | 5 | 0 | 24
10 | 10 | 0 | 24
11 | 5 | 0 | 17
12 | 1 | 0 | 17
13 | 8 | 0 | 17
14 | 2 | 0 | 17
15 | 1 | 0 | 17
COLUMN "A" = VALUES
COLUMN "B" = CURRENT OUTPUT (w/Formula Above)
COLUMN "C" = DESIRED OUTPUT
Thanks for your assistance.