Countifs formula help for multiple dropdown selections

Vicki Diaper

I am attempting to count different dropdown selections that have historically been amended. For example, where dropdown options were "Multi"; "M/A" but is now "Multi-Account", I need to count all 3 potential selections for a single year.

Where a single value has always existed, this is the formula I'm using:

=COUNTIFS({Master Sheet - Mentor Requests Range 7}, CONTAINS("Multi-Account",@cell), {Reporting Year}, "2022")

Thanks

Paul Newcome

Do you mean you are trying to count cells that contain either "Multi", "M/A", or "Multi--Account?

Vicki Diaper

Yes that's correct.

Paul Newcome

Ok. Try this...

=COUNTIFS({Master Sheet - Mentor Requests Range 7}, OR(CONTAINS("Multi",@cell), CONTAINS("M/A",@cell)), {Reporting Year}, "2022")

I only specified "Multi" and "M/A" because "Multi" will also grab "Multi-Account"