COUNTIFS on multiple columns looking for multiple conditions.

jambla ✭✭
edited 04/02/20 in Formulas and Functions


Im trying to count how many rows fit a specific criteria.

Here is my example table:

In this example I want to count how many rows are assigned to "In House" with a Status of "In" and Difficulty of "A".

This is my formula:

=COUNTIFS([Assigned To]:[Assigned To], "In House", [Status]:[Status], “In”,[Difficulty]:[Difficulty], “A” )

When I do that I get #UNPARSEABLE

Any help would be much appreciated!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!