Data Validation

New Contributor

I created a drop down list. However, I would like to tally the selections of each item. How can I achieve this?

3 Replies


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.