Adding alpha data

  • Thread starter Thread starter saltod75
  • Start date Start date
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?
 
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")
 
Back
Top