Counting how many options are selected in a cell?

Options

I am trying to count where there are multiple selectable options in a cell.

Tried using =Countifs but the issue I am having there is that it doesn't count the number of options selected, only the number of times specific criteria are selected.

I am trying to get to:

If option 1,2,3, or 4 is selected, it returns "1"

If any two options are selected it returns "2"

etc.

Any help is appreciated!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!