COUNTIFS using multiple ranges

I am so sorry this is so simple but I am new and eager to learn. I already googled and couldn't find.

I have a report that is counting how many tickets are in different countries and their severity. I want to know how many tickets Mexico has in Critical status.

So my fields are Country and Severity.

I can get a count of how many total tickets Mexico has COUNTIFS({Range 1}, "Mexico")

But I want to say how many tickets does Mexico have in "Critical" status

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!