Forum Discussion
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(...
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.
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.
