Forum Discussion
Data Validation
I created a drop down list. However, I would like to tally the selections of each item. How can I achieve this?
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-
Thanks! How do I do the COUNTIF?
- Please check the workbook for a sample.