Countifs with 3 ranges

Kristin Gregory

I am new to Smartsheet and formulas. I am needing a count of all rows that have HLE Status 'In Progress", HLE Request Type "Residential", and Assigned to "Timothy Biles". I have tried several ways but keep getting the error #UNPARSEABLE. I am able to get a count if using only two criteria but unable to add the third critera and it work.

David Joyeuse

Hi @Kristin Gregory

=COUNTIFS({HLE Status Range}, "In Progress", {HLE Request Type Range}, "Residential", {Assigned to Range}, "Timothy Biles")

That should do it.

David Joyeuse

Hi @Kristin Gregory

=COUNTIFS({HLE Status Range}, "In Progress", {HLE Request Type Range}, "Residential", {Assigned to Range}, "Timothy Biles")

That should do it.

Kristin Gregory

It worked, thanks for all your help!!!!!