AVE OR SUM

[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

 

[FSt1]

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

regards
FSt1

 

[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

 

[Jesse]

Thanks. I tried it and it works.

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

regards
FSt1

 

[Jesse]

Thanks Francis. I tried it and it works

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