Sum only positive numbers

[Fred Holmes]

Is there a way to write a SUM() formula so that it sums only the
positive numbers in the range and ignores the negative numbers?

I have a .csv download of my credit card transactions. I'd like to
easily sum the purchase transactions while ignoring the payment
transactions that are interspersed with the purchases.

Thanks for your help,

Fred Holmes

 

[Peo Sjoblom]

=SUMIF(A1:A100,">0")

 

[Harald Staff]

Hi Fred

=SUMIF(A1:A200,">0")

HTH. Best wishes Harald