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

@Clawrence635 

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?

@Patrick2788

Please check the workbook for a sample.