Is there a way to COUNTIF checked boxes, but have the formula skip over boxes with an error?
I have successfully implemented a formula in a sheet summary that COUNTIFS checked boxes in a column but because of the nature in which this sheet is being used, some of the checkboxes that I am counting have temporary #NO MATCH errors due to information not yet being available from other sheets which is thus causing the sheet summary field to return #NO MATCH as well. Is there a way to have my COUNTIFS not count rows that have an error so it only counts the checked boxes? Thank you!
Best Answer
-
You could use an IFERROR on the formula within the checkboxes to replace the error with a blank or even text that replicates the error. Even if it is the text, since it is generated text and not an automatic error, your COUNT formula should work.
Answers
-
You could use an IFERROR on the formula within the checkboxes to replace the error with a blank or even text that replicates the error. Even if it is the text, since it is generated text and not an automatic error, your COUNT formula should work.
-
That worked perfectly, thank you!
-
Happy to help. 👍️
Help Article Resources
Categories
Check out the Formula Handbook template!