How to count cells with a value in a column

Elisa Hogan

Hello,

Trying to figure out how to count cells with values in one column. For example:

I want to know how many cells contain a value on the following:

Column 2

Josh

Robert

Alexandra

Greg

My ideal answer would be that there are 4 values in column 2.

Any idea what the formula is for this?

I have the formula for blank cells:

=COUNTIF([Column2]2:[Column2]11, " ")

Thanks!

Elisa

Paul Newcome

"Not Equal To" is <>. So you would use that to say "not equal to blank".

=COUNTIFS([Column2]2:[Column2]11, <> "")