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

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)

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

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)

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

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

"Ohmer4j" wrote:

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)

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

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.

"bj" wrote:

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

"Ohmer4j" wrote:

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)

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

in that case your equation should be fine.


"Ohmer4j" wrote:

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.

"bj" wrote:

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

"Ohmer4j" wrote:

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)