=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