formula based on text information

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi all

I want to create a roster sheet with a formula that will return a result
based on the number of absentees.

I want to enter the words Holidays, Off or Sick, and have the formula
calculate the number of people absent on that day.

Does anyone know how to create this sort of formula based on alpha data?

thanks

Kathryn
 
=COUNTIF(A1:A100,"Holidays")

etc.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

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

Formula based on formatting? 1
Formula for Counta 3
using countif 3
Total Working hours If 2
Problem w/vlookup 5
Formula for attendance record 8
Finding the Last Working Day 16
What's the formula? 2

Back
Top