formula based on text information

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)


"Kathryn W" <[email protected]> wrote in message
news:[email protected]...
> 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

thanks for that

cheers

"Bob Phillips" wrote:

> =COUNTIF(A1:A100,"Holidays")
>
> etc.
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Kathryn W" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>