Countifs formula help for multiple dropdown selections


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")




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!