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!

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!

The COUNTIF function will work.

Hth,
Merjet