COUNTIF for multiple locations

ALEX BOSTROM

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.

Thanks,

Alex Bostrom

University of Utah Health

Paul Newcome

Try a COUNTM/COLLECT...

=COUNTM(COLLECT([Placement Location]:[Placement Location], [SPAH Responsible]:[SPAH Responsible], @cell = "Fred"))

Paul Newcome

Try a COUNTM/COLLECT...

=COUNTM(COLLECT([Placement Location]:[Placement Location], [SPAH Responsible]:[SPAH Responsible], @cell = "Fred"))

ALEX BOSTROM

Paul! Thank you so much this works perfectly.

Alex Bostrom

University of Utah Health

Paul Newcome

Happy to help. 👍️