COUNTIF for multiple locations


Hello SmartSheet Community,

I need a formula that will count the total number of locations in a multi-select drop-down column "Placement Location" and if the "SPAH Responsible" column = "Fred".

This is what I've been using but will not add multiple locations selected in one row. Do I need to add a sum formula in there?

=COUNTIFS([SPAH Responsible]:[SPAH Responsible], "Fred", [Placement Location]:[Placement Location],

For example, I need this to equal 3, not 2.


Alex Bostrom

University of Utah Health


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!