| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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.newusers
|
|||
|
|||
|
CUMULATIVE leaving 0
There's no need for multiple posts look in programming
"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.newusers
|
|||
|
|||
|
CUMULATIVE leaving 0
Hi Alimbilo
If I understand you right, all you need to do in a empty cell type =SUM(A1:C1) change range to your needs, and if a cell has a zero or nothing, it won't change the total. Regards Cimjet "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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
CUMULATIVE leaving 0
This is the change I just posted.
I forgot to tell you that between them there is othe fields so it should be: A1 = 3.2 F1 = 9.5 N1 = 6.9 R1 = cumulative of A1,F1 and N1 (giving a value even when one of them has 0 as value) Thanks "Cimjet" wrote: Hi Alimbilo If I understand you right, all you need to do in a empty cell type =SUM(A1:C1) change range to your needs, and if a cell has a zero or nothing, it won't change the total. Regards Cimjet "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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
CUMULATIVE leaving 0
=SUM(A1,F1,N1)
Gord Dibben MS Excel MVP On Tue, 10 Jun 2008 10:16:03 -0700, Alimbilo wrote: This is the change I just posted. I forgot to tell you that between them there is othe fields so it should be: A1 = 3.2 F1 = 9.5 N1 = 6.9 R1 = cumulative of A1,F1 and N1 (giving a value even when one of them has 0 as value) Thanks "Cimjet" wrote: Hi Alimbilo If I understand you right, all you need to do in a empty cell type =SUM(A1:C1) change range to your needs, and if a cell has a zero or nothing, it won't change the total. Regards Cimjet "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 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
CUMULATIVE leaving 0
I am not adding value. It's not a A+B+C+....
I am doing a cumulative sum which code is =Sum(A*B*C*...) If I have a 0, the all operation will be Null. And that what I am trying to avoid. "Gord Dibben" wrote: =SUM(A1,F1,N1) Gord Dibben MS Excel MVP On Tue, 10 Jun 2008 10:16:03 -0700, Alimbilo wrote: This is the change I just posted. I forgot to tell you that between them there is othe fields so it should be: A1 = 3.2 F1 = 9.5 N1 = 6.9 R1 = cumulative of A1,F1 and N1 (giving a value even when one of them has 0 as value) Thanks "Cimjet" wrote: Hi Alimbilo If I understand you right, all you need to do in a empty cell type =SUM(A1:C1) change range to your needs, and if a cell has a zero or nothing, it won't change the total. Regards Cimjet "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 |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
CUMULATIVE leaving 0
one solution
=if(a1=0,1,a1)*if(b1=0,1,b1)*if(c1=0,1,c1) -- Wag more, bark less "Alimbilo" wrote: I am not adding value. It's not a A+B+C+.... I am doing a cumulative sum which code is =Sum(A*B*C*...) If I have a 0, the all operation will be Null. And that what I am trying to avoid. "Gord Dibben" wrote: =SUM(A1,F1,N1) Gord Dibben MS Excel MVP On Tue, 10 Jun 2008 10:16:03 -0700, Alimbilo wrote: This is the change I just posted. I forgot to tell you that between them there is othe fields so it should be: A1 = 3.2 F1 = 9.5 N1 = 6.9 R1 = cumulative of A1,F1 and N1 (giving a value even when one of them has 0 as value) Thanks "Cimjet" wrote: Hi Alimbilo If I understand you right, all you need to do in a empty cell type =SUM(A1:C1) change range to your needs, and if a cell has a zero or nothing, it won't change the total. Regards Cimjet "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 | |||
| CUMULATIVE leaving 0 | Excel Discussion (Misc queries) | |||
| Copy a column leaving out any blanks | Excel Worksheet Functions | |||
| 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) | |||
Linear Mode
