COUNTIF Function Not Working Correctly


I have a COUNTIF function I am using to count all cells that are 'Blank' in a column. We should have one result, but the formula is showing as zero. Any thoughts on this one?

=COUNTIF([Account Dashboard]:[Account Dashboard], " ")

Best Answer

  • Matt Johnson
    Matt Johnson ✭✭✭✭✭✭
    Answer ✓

    Hi @ewitt19205

    Try removing the space between the quotes. You are counting all cells with 1 space in the cell. Blanks are counted with the quotes together.

    When counting blanks though, its also good to use a COUNTIFS and compare the blank off another column that always has a value. Like Countifs when the Project name is not blank (<>"") and the Account Dashboard is blank ("").

    I hope that helps.



    Matt Johnson

    Sevan Technology

    Smartsheet PLATINUM Partner


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!