COUNTIF or COUNTIFS to sum blank fields
I have many columns and I need to sum the number of blanks within a row. There are a few columns interspersed that are hidden helper columns that should not be included in the count. I have not been able to get a formula to work when trying to account (and not count) for the helper columns (in this example column 11 and 13).
What I tried: =COUNTIFS([Column 1]:[Column 10], ISBLANK(@cell), [Column 12]:[Column 12], ISBLANK(@cell), [Column 14]:[Column 20], ISBLANK(@cell))
I also tried converting to a column formula with @row after the ranges, but continue to get incorrect argument set.
Help Article Resources
Check out the Formula Handbook template!