Counting the number of times someone called in sick

How do I count the number of times a person has called in sick?

9/1/05 work
9/2/05 work
9/3/05 sick
9/4/05 sick
9/5/05 work
9/6/05 sick

The above example shows the person called in sick 2 times for 3 days.
How do I create a formula that reflects this?

thanks

Use the COUNTIF function. Something like

=COUNTIF(B1:B100,"sick")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"smskater" <[email protected]> wrote in message
news:[email protected]...
> How do I count the number of times a person has called in sick?
>
> 9/1/05 work
> 9/2/05 work
> 9/3/05 sick
> 9/4/05 sick
> 9/5/05 work
> 9/6/05 sick
>
> The above example shows the person called in sick 2 times for 3
> days.
> How do I create a formula that reflects this?
>
> thanks
>

Thanks, but this just shows the total for sick. How do I count the
occurrences?
Chip Pearson wrote:
> Use the COUNTIF function. Something like
>
> =COUNTIF(B1:B100,"sick")
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
> "smskater" <[email protected]> wrote in message
> news:[email protected]...
> > How do I count the number of times a person has called in sick?
> >
> > 9/1/05 work
> > 9/2/05 work
> > 9/3/05 sick
> > 9/4/05 sick
> > 9/5/05 work
> > 9/6/05 sick
> >
> > The above example shows the person called in sick 2 times for 3
> > days.
> > How do I create a formula that reflects this?
> >
> > thanks
> >

If you have something in those cells (and it looks like you do), you can use:

=counta(b1:b100)



smskater wrote:
>
> Thanks, but this just shows the total for sick. How do I count the
> occurrences?
> Chip Pearson wrote:
> > Use the COUNTIF function. Something like
> >
> > =COUNTIF(B1:B100,"sick")
> >
> >
> > --
> > Cordially,
> > Chip Pearson
> > Microsoft MVP - Excel
> > Pearson Software Consulting, LLC
> > www.cpearson.com
> >
> >
> > "smskater" <[email protected]> wrote in message
> > news:[email protected]...
> > > How do I count the number of times a person has called in sick?
> > >
> > > 9/1/05 work
> > > 9/2/05 work
> > > 9/3/05 sick
> > > 9/4/05 sick
> > > 9/5/05 work
> > > 9/6/05 sick
> > >
> > > The above example shows the person called in sick 2 times for 3
> > > days.
> > > How do I create a formula that reflects this?
> > >
> > > thanks
> > >

--

Dave Peterson