IF formula

[lance559]

I am trying to create a formula. I believe it may be an IF formula. If
summed numbers in a row are negative, I would like those numbers to be
auotmatically summed as 0.

For exmaple, if I have a row of ten numbers and three of the summed numbers
are negative, what formula could I use so the positive numbers remain, but
the negative numbers will be 0? Thanks.

[Don Guillett]

Have a look in help index for SUMIF

--
Don Guillett
SalesAid Software
[email protected]
"lance559" <[email protected]> wrote in message
news:[email protected]...
> I am trying to create a formula. I believe it may be an IF formula. If
> summed numbers in a row are negative, I would like those numbers to be
> auotmatically summed as 0.
>
> For exmaple, if I have a row of ten numbers and three of the summed
numbers
> are negative, what formula could I use so the positive numbers remain, but
> the negative numbers will be 0? Thanks.

[Anne Troy]

=SUMIF(A2:A12,">0")
************
Anne Troy
www.OfficeArticles.com

"lance559" <[email protected]> wrote in message
news:[email protected]...
>I am trying to create a formula. I believe it may be an IF formula. If
> summed numbers in a row are negative, I would like those numbers to be
> auotmatically summed as 0.
>
> For exmaple, if I have a row of ten numbers and three of the summed
> numbers
> are negative, what formula could I use so the positive numbers remain, but
> the negative numbers will be 0? Thanks.

[lance559]

I am not doing something right.

For example,

H70 (50) (this is sum from another cell)
H71 100

H72 50 (sum of H70 & H71)

How do I make row 70 a 0 so the sum will automatically calculate in row H72
as 100.

"Anne Troy" wrote:

> =SUMIF(A2:A12,">0")
> ************
> Anne Troy
> www.OfficeArticles.com
>
> "lance559" <[email protected]> wrote in message
> news:[email protected]...
> >I am trying to create a formula. I believe it may be an IF formula. If
> > summed numbers in a row are negative, I would like those numbers to be
> > auotmatically summed as 0.
> >
> > For exmaple, if I have a row of ten numbers and three of the summed
> > numbers
> > are negative, what formula could I use so the positive numbers remain, but
> > the negative numbers will be 0? Thanks.
>
>
>

[Anne Troy]

Works fine for me, Lance: =SUMIF(H70:H71,">0")
************
Anne Troy
www.OfficeArticles.com

"lance559" <[email protected]> wrote in message
news:[email protected]...
>I am not doing something right.
>
> For example,
>
> H70 (50) (this is sum from another cell)
> H71 100
>
> H72 50 (sum of H70 & H71)
>
> How do I make row 70 a 0 so the sum will automatically calculate in row
> H72
> as 100.
>
> "Anne Troy" wrote:
>
>> =SUMIF(A2:A12,">0")
>> ************
>> Anne Troy
>> www.OfficeArticles.com
>>
>> "lance559" <[email protected]> wrote in message
>> news:[email protected]...
>> >I am trying to create a formula. I believe it may be an IF formula. If
>> > summed numbers in a row are negative, I would like those numbers to be
>> > auotmatically summed as 0.
>> >
>> > For exmaple, if I have a row of ten numbers and three of the summed
>> > numbers
>> > are negative, what formula could I use so the positive numbers remain,
>> > but
>> > the negative numbers will be 0? Thanks.
>>
>>
>>

[lance559]

You are fabulous! Thanks so much.

"Anne Troy" wrote:

> Works fine for me, Lance: =SUMIF(H70:H71,">0")
> ************
> Anne Troy
> www.OfficeArticles.com
>
> "lance559" <[email protected]> wrote in message
> news:[email protected]...
> >I am not doing something right.
> >
> > For example,
> >
> > H70 (50) (this is sum from another cell)
> > H71 100
> >
> > H72 50 (sum of H70 & H71)
> >
> > How do I make row 70 a 0 so the sum will automatically calculate in row
> > H72
> > as 100.
> >
> > "Anne Troy" wrote:
> >
> >> =SUMIF(A2:A12,">0")
> >> ************
> >> Anne Troy
> >> www.OfficeArticles.com
> >>
> >> "lance559" <[email protected]> wrote in message
> >> news:[email protected]...
> >> >I am trying to create a formula. I believe it may be an IF formula. If
> >> > summed numbers in a row are negative, I would like those numbers to be
> >> > auotmatically summed as 0.
> >> >
> >> > For exmaple, if I have a row of ten numbers and three of the summed
> >> > numbers
> >> > are negative, what formula could I use so the positive numbers remain,
> >> > but
> >> > the negative numbers will be 0? Thanks.
> >>
> >>
> >>
>
>
>

[Anne Troy]

Oh, cool! I thought it wasn't going to work again, and we were gonna have to
figure out why!
Glad to hear it.
************
Anne Troy
www.OfficeArticles.com

"lance559" <[email protected]> wrote in message
news:[email protected]...
> You are fabulous! Thanks so much.
>
> "Anne Troy" wrote:
>
>> Works fine for me, Lance: =SUMIF(H70:H71,">0")
>> ************
>> Anne Troy
>> www.OfficeArticles.com
>>
>> "lance559" <[email protected]> wrote in message
>> news:[email protected]...
>> >I am not doing something right.
>> >
>> > For example,
>> >
>> > H70 (50) (this is sum from another cell)
>> > H71 100
>> >
>> > H72 50 (sum of H70 & H71)
>> >
>> > How do I make row 70 a 0 so the sum will automatically calculate in row
>> > H72
>> > as 100.
>> >
>> > "Anne Troy" wrote:
>> >
>> >> =SUMIF(A2:A12,">0")
>> >> ************
>> >> Anne Troy
>> >> www.OfficeArticles.com
>> >>
>> >> "lance559" <[email protected]> wrote in message
>> >> news:[email protected]...
>> >> >I am trying to create a formula. I believe it may be an IF formula.
>> >> >If
>> >> > summed numbers in a row are negative, I would like those numbers to
>> >> > be
>> >> > auotmatically summed as 0.
>> >> >
>> >> > For exmaple, if I have a row of ten numbers and three of the summed
>> >> > numbers
>> >> > are negative, what formula could I use so the positive numbers
>> >> > remain,
>> >> > but
>> >> > the negative numbers will be 0? Thanks.
>> >>
>> >>
>> >>
>>
>>
>>