How to exclude negative numbers from the sum of a column

G

Garth

The subject says it all...I want to sum the numbers in a column that
are > or = to 0.

Thanks
 
C

charlie

Assuming the column in question is column A, try the following: =COUNTIF(A:A, ">=0")

This will also not count blanks cells.
 
J

Jerry W. Lewis

I think you meant =SUMIF(A:A, ">=0")

Jerry
Assuming the column in question is column A, try the following: =COUNTIF(A:A, ">=0")

This will also not count blanks cells.
Click to expand...
 
Top