Menu
Is there a way to add up all of the positive numbers in a row/column but ignoring all of the negative numbers? Like SUM(), except that it ignores negative numbers. Would I have to use VBA? If so, how would I do it in VBA?
If it can't be done in Excel, can it be done in OpenOffice Calc?
616
asked Oct 20 '09 19:10
Excel's SUMIF function lets you add up numbers that match specified criteria in a range of cells. As such, this is the best way to selectively add up positive numbers. In this function, range is the range of cells containing the data you want the function to work on.
Use SUMIF. YTo sum all the positive numbers in Column A:
=SUMIF(A:A,">0")
Same function exists in Excel and Calc
169
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
