Countif with multi values and variations

shawn liston

I have countifs statement but then need to account for multi-value dropdown list and wonder the best way to capture the values. So counting projects status of in project - with a business value of 6 options (multi-value).

So Business Value column has multi-value options from a drowndown. I really only care about the total number of projects that have business value of cost savings and not the variations that may be in that column given that it's a multi-value.

I have the countifs portion - just not multi values.

AKnight

Hi @shawn liston !

I would check out the HAS function. It will allow you to look through the multiselect column for when "cost savings" is selected.