the count function will do the trick. You just need a list of each person
last name somewhere in the workbook.

" wrote:


I have a schedule which exists as a large table in a spreadsheet.
Each cell (a person's last name) represents a shift that a person has
signed up for. I would like to have an easy way display the total
number of shifts that a person has signed up for on the schedule (i.e.
the total number of times that person's name appears in the
spreadsheet). Is this possible?

Thanks so much!