Count cells within a column that are not blank

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.

Tags:

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    edited 11/03/23 Answer ✓

    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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!