Forum Discussion

kittenmeants's avatar
kittenmeants
Brass Contributor
Jul 14, 2023

Formula Help: Count Blanks

Hello!   So I have a tracking spreadsheet that currently counts how many of an item we report as Yes and No. We also have to account for blanks.   The current formula I am using is : =COUNTBLANK(...
  • flexyourdata's avatar
    Jul 14, 2023

    kittenmeants 

     

    Suppose your headers are in column A and your yes/no values are in column B. 

     

    Then you can count the blanks in column B on non-header rows with this formula:

    =COUNTIFS(A1:A14,"",B1:B14,"")

    I.e. count those rows where both A and B are blank. 

Resources