Data Validation

[Clawrence635]

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

[#2]

@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-

[#3]

Thanks! How do I do the COUNTIF?

@Patrick2788

[#4]

Please check the workbook for a sample.