G
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)
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)