How to Count Number of Selected Options in a Multiple Select Field Using Formulas

[Charles_Turner]

I have a multiple select field with four options: 2020, 2021, 2022, 2023. 

I want a formula field that prints how many of these options were selected. 

I played a bit with Count and If statements, but couldn't get anything to function quite right. 

Any help appreciated! 

[Jack_Manuel]

You can use this formula from Airtable themselves.

[airballer86]

@Charles_Turner I was trying to find the same thing and @bruceconsulting has an easier formula that doesn't require turning the multiple select in to a lookup table: https://community.airtable.com/t5/formulas/creating-an-if-statement-for-multiple-options-in-a-field/... 

[Elias_Gomez_Sai]

What do you mean? It's exactly the same formula.

[airballer86]

@Elias_Gomez_Sai yes. That was over a year ago, I never responded to say that.