COUNTIFS with multiple criteria in same range and different ranges


@Paul Newcome, would you be able to help me with a COUNTIFS formula that contains multiple criteria within the same range and within different ranges?

This count works with multiple criteria and multiple ranges, but now I need to add another criterion ("insect") within the same Metrics Range 3.

=COUNTIFS({Metrics Range 3}, "Bug", {Metrics Range 1}, "Race 18", {Metrics Range 5}, "Defect", {Metrics Range 6}, "Race 18 SD")

Thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!