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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Ohmer4j" wrote in message
...
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)