Total from Dropdown column with multiple values
I have a sheet with columns with multiple (20+) dropdown options. A cell can contain more than one dropdown item
I want to create a report to go up to a dashboard that shows the count of each time a dropdown is used regardless of whether it's on its own in a cell or with other items.
e.g. over 10 rows from 1 column, dropdown 1 could feature 5 times, but dropdown 2, 15 and dropdown 3 12.
I'm looking to produce a graph to demonstrate this information.
Any simple instructions that you could provide would be great - I'm not the best with formulas so it may take a bit for me to decode what you're advising! 😊