Countifs formula help for multiple dropdown selections

Options

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

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!