=COUNTIF(A1:A100,"Holidays")

etc.

--

HTH

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


"Kathryn W" wrote in message
...
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