hi
try this
=SUMIF(B2:B6,"0",B2:B6)

regards
FSt1

"Jesse" wrote:

I'm wondering if there is a formula that will omit a number from a table
when it is negative. If so, please inform me how to add it to a formula that
looks like this:
=sum(B2:b6)
Im import this data form other file and some times one of the cells come
with -99 which is not part of this calculation
Thanks.
B
70 70
72 -99
68 64
-99 -99
72 71