Forum Discussion

kittenmeants's avatar
kittenmeants
Copper Contributor
Jul 14, 2023
Solved

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(...
Formulas and Functions
  • flexyourdata's avatar
    flexyourdata
    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. 

kittenmeants's avatar
kittenmeants
Copper Contributor
Jul 14, 2023
I added an example in my original post. The headers are embedded throughout the column.Thank you!

Resources