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!