Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CUMULATIVE leaving 0
I would like to calculate a cumulative of:
A1 = 3.2 B1 = 9.5 C1 = 6.9 I want D1 to be the result of the cumulative of A1, B1 and C1 only if they have a value different than 0. I want to be able to have a cumulative even though one of them has 0 as value. Any Help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
CUMULATIVE leaving 0
You have an answer (Guess) in your other post
"Alimbilo" wrote: I would like to calculate a cumulative of: A1 = 3.2 B1 = 9.5 C1 = 6.9 I want D1 to be the result of the cumulative of A1, B1 and C1 only if they have a value different than 0. I want to be able to have a cumulative even though one of them has 0 as value. Any Help |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
CUMULATIVE leaving 0
Cumulative sum, cumulative product, cumulative differences, ... ?
In other words, cumulative what? [Cumulative is an adjective, so you need to use it to describe a noun.] If you are worrying about the zeroes then perhaps it is a product you are trying to produce, but you need to be clear. -- David Biddulph "Alimbilo" wrote in message ... I would like to calculate a cumulative of: A1 = 3.2 B1 = 9.5 C1 = 6.9 I want D1 to be the result of the cumulative of A1, B1 and C1 only if they have a value different than 0. I want to be able to have a cumulative even though one of them has 0 as value. Any Help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy a column leaving out any blanks | Excel Worksheet Functions | |||
numbers are being divided by 100 on leaving cell | Excel Discussion (Misc queries) | |||
How to delete values in each row leaving only last value ? | Excel Discussion (Misc queries) | |||
Leaving a cell blank. Not NA(), not "". | Excel Worksheet Functions | |||
Remove ALL duplicated records, leaving behind NONE | Excel Discussion (Misc queries) |