Proper Name Totals

U

uconnem

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!
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding up total hours worked on employee schedule using various criteria 0
Access Dcount (multiple criteria) 3
Formula Help 1
Excel 2 into 1 6
Multiple printing of cell data onto new worksheet 2
scheduled hours total 1
Excel Is this possible?? 3
Automatically Color Autoshape and Autoshape Naming 2

Top