sum reducing range down a column

[stephme55]

Hello.

In B15, I have the following formula = sum(C4:11). How can I drag this formula down a column but have it remove one column from the sum formula for each row down.

So, in B16 = sum(C4:C10), in B17= sum(C4:C10) and so on. Dankeshun!!!

[mehmetcik]

Please Login or Register  to view this content.

[newdoverman]

Replace your formula in B15 with this one and fill down:

Please Login or Register  to view this content.

This will reduce the sum from C4:C11 backwards C4:C10, C4:C9 etc.

	B	C
4		1
5		2
6		3
7		4
8		5
9		6
10		7
11		8
12
13
14
15	36
16	28
17	21
18	15
19	10
20	6
21	3
22	1