count value

Kyle Black

I need a formula that will count cells in a column that have any value in them that is not zero

Heather Duff

Hi Kyle,

Easy peasy! You should be able to use the COUNT formula:

=COUNT([column name]:[column name])

It will count all cells that are not blank.

Best,

Heather

Kyle Black

what is the cell has a 0 in it?

Kelly Moore

Hey @Kyle Black

In case your zero's are still giving you an issue, try this

=COUNTIFS([column name]:[column name], >0)