maybe, =SUMIF(A1:A10,"0")
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"LD6892" wrote in message
...
How do I omit a cell that contains a negative number in an addition
formula?
I can't use sum because there are cells in between.