| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
| 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
