Adding alpha data

S

saltod75

I have several staffplans that I use to add weekly hours worked. Is it
possible to set up a formula that will add together staff names to give me a
total number of times they appear within the plan?
 
G

Gary''s Student

If you have a list of names in a column and want to know how many times a
givem name appears:

=COUNTIF(A1:A100,"Smith")
 
Top