Count cells within a column that are not blank

Jonnell Sherman

Hi all, trying to work out a formula to count how many cells have an entry (number or text). Can not find a formula for "is not blank". Please help.

Genevieve P.

I agree with @jmyzk_cloudsmart_jp!

Another way of doing this is to use the <> operator to say "does not equal" and then two quotes with nothing int them "" to indicate "blank".

So:

=COUNTIF([Column Name]:[Column Name], <> "")

Keep in mind that a COUNT formula will only count non-blank cells already, so you could just do COUNT like so:

=COUNT([Column Name]:[Column Name])

Cheers,

Genevieve

jmyzk_cloudsmart_jp

@Jonnell Sherman

NOT(ISBLANK())

Genevieve P.

I agree with @jmyzk_cloudsmart_jp!

Another way of doing this is to use the <> operator to say "does not equal" and then two quotes with nothing int them "" to indicate "blank".

So:

=COUNTIF([Column Name]:[Column Name], <> "")

Keep in mind that a COUNT formula will only count non-blank cells already, so you could just do COUNT like so:

=COUNT([Column Name]:[Column Name])

Cheers,

Genevieve