IF formula
 

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.

IF formula
 

Have a look in help index for SUMIF

--
Don Guillett
SalesAid Software

"lance559" wrote in message
...
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.

IF formula
 

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

"lance559" wrote in message
...
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.

IF formula
 

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" wrote in message
...
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.

IF formula
 

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

"lance559" wrote in message
...
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" wrote in message
...
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.

IF formula
 

You are fabulous! Thanks so much.

"Anne Troy" wrote:

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

"lance559" wrote in message
...
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" wrote in message
...
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.

IF formula
 

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" wrote in message
...
You are fabulous! Thanks so much.

"Anne Troy" wrote:

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

"lance559" wrote in message
...
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" wrote in message
...
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.