Forum Discussion
kittenmeants
Jul 14, 2023Brass Contributor
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(...
- Jul 14, 2023
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.
flexyourdata
Jul 14, 2023Iron Contributor
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.