Proper Name Totals
 

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!

Proper Name Totals
 

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!

Proper Name Totals
 

The COUNTIF function will work.

Hth,
Merjet