Hi

Assuming your data start from A2, in A7, try this formula

=SUMIF(A2:A6,"0")

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"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