Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CUMULATIVE SUM
Hi All,
I'm trying to add a row of numbers, (some blank cells) and I only want it to add when there is a number to add. In other words: A1= 4 B1=2, I would like to have "6" in C1, but if there is a blank in D1, I would like the 6 to appear again. If there is a 1 in E1, I would the the formula to add the 6 from D1 and replace the 1 in E1 with a "7". I don't want the cells to add up like 6+1+7. I don't want a running total, I want a (I'm thinking cumulative). thank you so much, sherry -- sherry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CUMULATIVE SUM? | Excel Discussion (Misc queries) | |||
Cumulative frequency | Excel Discussion (Misc queries) | |||
Cumulative Return | Excel Worksheet Functions | |||
Cumulative Sum | Excel Worksheet Functions |