| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| rolling document number | Excel Discussion (Misc queries) | |||
| 12 month Rolling Total | Excel Worksheet Functions | |||
| how do I increase the number of cells I want to total | Excel Discussion (Misc queries) | |||
| total cells with text and number EX: GS-5 | Excel Worksheet Functions | |||
| Counting the total number of cells with specified condition(freque | Excel Discussion (Misc queries) | |||
Threaded Mode
