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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!