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

=SUMIF(A1:A100,"0")

--
Regards,

Peo Sjoblom


"Fred Holmes" wrote in message
...
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

Hi Fred

=SUMIF(A1:A200,"0")

HTH. Best wishes Harald

"Fred Holmes" skrev i melding
...
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