Count column that is blank and another column that is not blank


I am trying to do a formula to count how many files are not yet audited:

where my "closed/referred date" column is not blank, but the "audited" column is blank.

Ive looked at other examples, but keep getting unpareseable errors any help would be greatly appreciated

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hi @lesmickin

    It looks like your "Audited" column is a Checkbox type of column, is that correct? If so, instead of looking for "" (which looks for blank) you'll actually want to look for an un-checked box, or 0.

    Try this:

    =COUNTIFS([Closed/Referred Date]:[Closed/Referred Date], <>"", Audited:Audited, 0)