I have a spreadsheet that I have used code to allow multiselect options from a pull down menu and separate those selections into one cell using a comma. This has worked successfully, what I need now is the formula to count each time each one of those in the pull down menu is selected to provide an updated total. The formula I had tried to use is =SUM(TRIM(TEXTSPLIT(TEXTJOIN(",",,$U$36:U75),","))=U77) and although it does not provide an error code, it does not return any values.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Sum of textsplit textjoin multiselect using pull down
- Thread starter ShanaStJ
- Start date
Fluff
MrExcel MVP, Moderator
- Joined
- Jun 12, 2014
- Messages
- 92,717
- Office Version
- 365
- Platform
- Windows
Duplicate to: Sum for textsplit textjoin selections from one cell
In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.
In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.
In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.
In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.
Upvote
0
- Status
Similar threads
