Forum Discussion
kittenmeants
Jul 14, 2023Copper 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
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?
- kittenmeantsJul 14, 2023Copper ContributorI added an example in my original post. The headers are embedded throughout the column.Thank you!
- SergeiBaklanJul 14, 2023MVP