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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cumulative formula for word table 0
Setting column width in a table with a macro is not working 0
How to count the numbers in a Word document? 0
How can the font and size of (all) citation numbers be altered? 1
Excel does not accept text format! 0
Automatically Scheduled Task with Start on Constraint and Neg Slack 0
Change the colour of a neighbouring cell 6
Getting the Vertical SUM of a (Custom-Calculated) Duration Field?? 0

Top