AVE OR SUM

J

Jesse

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
 
F

Francis

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
 
J

Jesse

Thanks Francis. I tried it and it works

Francis said:
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
Click to expand...
 
Top