Forum Discussion
Clawrence635
Nov 29, 2022Copper Contributor
Data Validation
I created a drop down list. However, I would like to tally the selections of each item. How can I achieve this?
3 Replies
- Patrick2788Silver Contributor
You could base the data validation choices off a named range. Then run a COUNTIF off the named range to obtain the tallies.
Sample attached-- Clawrence635Copper Contributor
Thanks! How do I do the COUNTIF?
- Patrick2788Silver ContributorPlease check the workbook for a sample.