Countifs with multiple choices in one row AND one choice in another row


Im trying to narrow down a count based if one of several choices in one column PLUS only one specific choice in another column

=COUNTIFS([Status:Status], "Discharged") + COUNTIFS([Status:Status], "Lost to Follow-up") + COUNTIFS([Status:Status], "Follow-up completed") + COUNTIFS([Status:Status], "Deceased"),CONTAINS([Provider:Provider], "Cherian")

I think I need to change the phrasing of the one specific choice in last part in bold.

how should I phrase this?

Appreciate help!!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!