Forum Discussion
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(...
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.
Are all 11 headers at the top of the sheet or are they embedded in the column?
Are there blanks in the header rows which can't be considered 'true' blanks for this calculation?
Can you share a file or mocked up example to help explain a little better?
Are there blanks in the header rows which can't be considered 'true' blanks for this calculation?
Can you share a file or mocked up example to help explain a little better?
- I added an example in my original post. The headers are embedded throughout the column.Thank you!
