Countifs with 3 ranges


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.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!