sum of rolling (set number cells above the total)l

[Guest]

How do you set a formula so it gets sum of a set number of cells above it in
the same column. Then so that formula will roll down and still only give sum
of the given number of cells. So it only totals the 5 cells immediatly above
it, even if it is moved down some rows. Example cell b11 =sum(b4:b10) so
it will roll down 10 rows and be b21 =sum(b14:b20)

 

[Bernard Liengme]

If B11 has formula =SUM(B4:B10) it is summing 7 cells above it
If I drag the fill handle (small solid square in lower right corner of
active cell) so as to copy this down the column, then at cell B21 is will
have =SUM(B14:B20) which sums 7 cell above it.

Have you tried it? Or am I missing something?
best wishes

 

[Guest]

what do you mean by roll down?
are you inserting this into an existing column and replacing the value that
was there before?

 

[Guest]

I was trying to set up where I could get a sum of the column and then insert
more rows, the formula would just move down and only use the set number of
cells above and not all the cells from the top of the column.

 

[Guest]

in that case your equation should be fine.

I was trying to set up where I could get a sum of the column and then insert
more rows, the formula would just move down and only use the set number of
cells above and not all the cells from the top of the column.