There are several ways. I am a fan of SUMPRODUCT.

If your schedule contains the names in B2:B81, use
=SUMPRODUCT(--(B2:B81="name")) where "name" is the person's name in quotes or
a reference to the person's name without quotes.

"Tidejwe" wrote:

I have set up a spread sheet where each cell represents an employee covering
a half hr shift during a certain time of day and want it to sum up how many
cells contain each person's name. Therefore if their name is listed 80 times
that week I know we have them scheduled to cover 40 hrs (or whatever they
need that week).

Can anyone tell me how I can set up an equation to automatically sum/total
the number of times that a specific word/name is found in a cell or just in
the spread sheet in general? It would be most helpful!