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")
 
You must log in or register to reply here.

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 cells by 2 criteria that move. 1
Adding Multi-part Formula 3
Alpha & Numeric Counts in Excel 3
running total where old data is replaced by new data 1
Pulling data from other spreadsheets 1
Combining Duplicate Data 1
ADDING HOURS AND MINUTES 2
VBA - retrieve data on last create named range from previous inserted named range 0

Back
Top