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

Maybe

=SUM(A1:C1)

Mike

"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

You have posted this in many places when ONE will do. This is considered to
be rude and undesirable.
Where do you want the answer.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"Alimbilo" <(E-Mail Removed)> wrote in message
news:F8C428F4-0142-4853-8630-(E-Mail Removed)...
>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

Did not mean to be rude. I am just trying to get an answer as soon as possible.
Sorry about that.
Can you help me then?

Thanks

"Don Guillett" wrote:

> You have posted this in many places when ONE will do. This is considered to
> be rude and undesirable.
> Where do you want the answer.
>
> --
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> (E-Mail Removed)
> "Alimbilo" <(E-Mail Removed)> wrote in message
> news:F8C428F4-0142-4853-8630-(E-Mail Removed)...
> >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
>
>

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

"Mike H" wrote:

> Maybe
>
> =SUM(A1:C1)
>
> Mike
>
> "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

If?? you want a1:r1 then use that in the sum formula.
or to only sum three cells
=SUM(I6,J8,I9)

Have you bothered to look in the help index for
SUM
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"Alimbilo" <(E-Mail Removed)> wrote in message
news:E1E9FB3F-3633-4802-9DBF-(E-Mail Removed)...
>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
>
> "Mike H" wrote:
>
>> Maybe
>>
>> =SUM(A1:C1)
>>
>> Mike
>>
>> "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

I did look in the SUM help and there is nothing about Sum if somevalue are 0.
Can someone really help?



"Don Guillett" wrote:

> If?? you want a1:r1 then use that in the sum formula.
> or to only sum three cells
> =SUM(I6,J8,I9)
>
> Have you bothered to look in the help index for
> SUM
> --
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> (E-Mail Removed)
> "Alimbilo" <(E-Mail Removed)> wrote in message
> news:E1E9FB3F-3633-4802-9DBF-(E-Mail Removed)...
> >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
> >
> > "Mike H" wrote:
> >
> >> Maybe
> >>
> >> =SUM(A1:C1)
> >>
> >> Mike
> >>
> >> "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
>
>

Consider the following for your future postings...

From a post by Jeff Johnson:

"You have posted this question individually to multiple groups.
This is called Multiposting and it's BAD. Replies made in one
group will not be visible in the other groups, which may cause
multiple people to respond to your question with the same answer
because they didn't know someone else had already done it. This
is a waste of time.

If you MUST post your message to multiple groups, post a single
message and select all the groups (or type their names manually
in the Newsgroups field, separated by commas) in which you want
it to be seen. This is called Crossposting and when used properly
it is GOOD."

Some additional comment previously posted by me:

"You may not see this as a problem, but those of us who volunteer
answering questions on newsgroups do see it as a problem. You can't
imagine how annoying it is for a volunteer to read a question,
research background material, test sample code and then formulate
and post an answer to the original question only to go to another
newsgroup and find the question posted and ALREADY answered over
there. On top of that, if you cross-post your question, all of the
readers in all the newsgroups it is cross-posted to see both the
original question and all of the answers given to it. This is
beneficial to you because then we can add additional material to,
add clarification to, as well as add additional examples to an
answer you have received previously... that means you end up with
a more complete solution to your problem. This is a win-win
situation for all of us."

Rick


"Alimbilo" <(E-Mail Removed)> wrote in message
news:1353F288-219E-46F1-9450-(E-Mail Removed)...
> Did not mean to be rude. I am just trying to get an answer as soon as
> possible.
> Sorry about that.
> Can you help me then?
>
> Thanks
>
> "Don Guillett" wrote:
>
>> You have posted this in many places when ONE will do. This is considered
>> to
>> be rude and undesirable.
>> Where do you want the answer.
>>
>> --
>> Don Guillett
>> Microsoft MVP Excel
>> SalesAid Software
>> (E-Mail Removed)
>> "Alimbilo" <(E-Mail Removed)> wrote in message
>> news:F8C428F4-0142-4853-8630-(E-Mail Removed)...
>> >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
>>
>>

??? I don't understand the problem you are having... if you are adding
values, and some of those values are 0, then they will add nothing to the
summation of the other values; so, you do not have to specifically exclude
them since including them will not change the resulting summation. Or are
there other considerations you did not tell us about that affects this in
some way?

Rick


"Alimbilo" <(E-Mail Removed)> wrote in message
news:66430F50-F3B0-4A5D-BCC3-(E-Mail Removed)...
>I did look in the SUM help and there is nothing about Sum if somevalue are
>0.
> Can someone really help?
>
>
>
> "Don Guillett" wrote:
>
>> If?? you want a1:r1 then use that in the sum formula.
>> or to only sum three cells
>> =SUM(I6,J8,I9)
>>
>> Have you bothered to look in the help index for
>> SUM
>> --
>> Don Guillett
>> Microsoft MVP Excel
>> SalesAid Software
>> (E-Mail Removed)
>> "Alimbilo" <(E-Mail Removed)> wrote in message
>> news:E1E9FB3F-3633-4802-9DBF-(E-Mail Removed)...
>> >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
>> >
>> > "Mike H" wrote:
>> >
>> >> Maybe
>> >>
>> >> =SUM(A1:C1)
>> >>
>> >> Mike
>> >>
>> >> "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
>>
>>

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.




"Rick Rothstein (MVP - VB)" wrote:

> ??? I don't understand the problem you are having... if you are adding
> values, and some of those values are 0, then they will add nothing to the
> summation of the other values; so, you do not have to specifically exclude
> them since including them will not change the resulting summation. Or are
> there other considerations you did not tell us about that affects this in
> some way?
>
> Rick
>
>
> "Alimbilo" <(E-Mail Removed)> wrote in message
> news:66430F50-F3B0-4A5D-BCC3-(E-Mail Removed)...
> >I did look in the SUM help and there is nothing about Sum if somevalue are
> >0.
> > Can someone really help?
> >
> >
> >
> > "Don Guillett" wrote:
> >
> >> If?? you want a1:r1 then use that in the sum formula.
> >> or to only sum three cells
> >> =SUM(I6,J8,I9)
> >>
> >> Have you bothered to look in the help index for
> >> SUM
> >> --
> >> Don Guillett
> >> Microsoft MVP Excel
> >> SalesAid Software
> >> (E-Mail Removed)
> >> "Alimbilo" <(E-Mail Removed)> wrote in message
> >> news:E1E9FB3F-3633-4802-9DBF-(E-Mail Removed)...
> >> >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
> >> >
> >> > "Mike H" wrote:
> >> >
> >> >> Maybe
> >> >>
> >> >> =SUM(A1:C1)
> >> >>
> >> >> Mike
> >> >>
> >> >> "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
> >>
> >>
>
>