Is there a way to COUNTIF checked boxes, but have the formula skip over boxes with an error?

Hunter Vaught

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!

Paul Newcome

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.

Paul Newcome

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.

Hunter Vaught

That worked perfectly, thank you!

Paul Newcome

Happy to help. 👍️