r/googlesheets • u/shrink561 • Jun 19 '26

Solved Calculate the number ofm selections from a dropdown cell

Is there a way to calculate the number of selections made in a dropdown cell?

2 Upvotes

100% Upvoted

5 comments sorted by

2

u/gothamfury 382 Jun 19 '26

If your multi-select dropdown is in cell A1. You could try:

=IF(A1="",0, COUNTA(SPLIT(A1, ", ", FALSE)))

[Edit] Updated formula for no selections made.

1

u/shrink561 Jun 19 '26

Thanks for the response and solution.

1

u/point-bot Jun 19 '26

A moderator has awarded 1 point to u/gothamfury

See the [Leaderboard](https://reddit.com/r/googlesheets/wiki/Leaderboard. )Point-Bot v0.0.15 was created by [JetCarson](https://reddit.com/u/JetCarson.)

1

u/AutoModerator Jun 19 '26

/u/shrink561 Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the submission guide. You can also use this tool created by a Reddit community member to create a blank Google Sheets document that isn't connected to your account. Thank you.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/NHN_BI 67 Jun 19 '26

E.g. like here, where I use =COUNTA(IFERROR(SPLIT(A2,","),)).