Hello,

Ive created a calendar-type spreadsheet with each month on a separate sheet. Each day has a dropdown list with 5 names to choose from.

I would like to know if there is a way that Excel could count how many times each option has been chosen throughout the spreadsheet (ie: the frequency of each of the 5 options would add up to 365).

Thanks in advance!