+ Reply to Thread
Results 1 to 4 of 4

Counting the number of times someone called in sick

  1. #1
    smskater
    Guest

    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


  2. #2
    Chip Pearson
    Guest

    Re: Counting the number of times someone called in sick

    Use the COUNTIF function. Something like

    =COUNTIF(B1:B100,"sick")


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


    "smskater" <Smskater@gmail.com> wrote in message
    news:1126825921.212344.21180@g44g2000cwa.googlegroups.com...
    > 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
    >




  3. #3
    smskater
    Guest

    Re: Counting the number of times someone called in sick

    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" <Smskater@gmail.com> wrote in message
    > news:1126825921.212344.21180@g44g2000cwa.googlegroups.com...
    > > 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
    > >



  4. #4
    Dave Peterson
    Guest

    Re: Counting the number of times someone called in sick

    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" <Smskater@gmail.com> wrote in message
    > > news:1126825921.212344.21180@g44g2000cwa.googlegroups.com...
    > > > 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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1