ExcelBanter - Sum only positive numbers

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sum only positive numbers (https://www.excelbanter.com/excel-discussion-misc-queries/24346-sum-only-positive-numbers.html)

Fred Holmes

Sum only positive numbers

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")

--
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

Harald Staff

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

All times are GMT +1. The time now is 07:24 AM.