View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ohmer4j Ohmer4j is offline
external usenet poster
 
Posts: 2
Default 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)