Count If with 3 Criteria

Hi -

Trying to count cells that are 1) Active, 2) have Completed - Not Implemented interiors, and 3) Completed exteriors. I thought count if would be best, but I'm receiving an "Incorrect Argument Set" error. Not sure of the best way to set this up...

=COUNTIFS({TRACKING SHEET Range 11}, "Completed - Not Implemented", {TRACKING SHEET Range 10}, "Completed", {TRACKING SHEET Range 26}, "Active")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!