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.