COUNTIF Function Not Working Correctly

Hello,

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.

    Thanks,

    Matt

    Matt Johnson

    Sevan Technology

    Smartsheet PLATINUM Partner

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!