+ Reply to Thread
Results 1 to 4 of 4

Find Count of Items with certain criteria

  1. #1
    Tucson Guy
    Guest

    Find Count of Items with certain criteria

    I have over a thousand records (Each one a legal case)

    Col I has the date the case was opened ( All cases have a "Date Opened")
    If a Case has been "Put on Hold", Col O has the date it was "POH". If not,
    Col O is blank
    If a case has been "awarded" Col R has the date it was awarded. If not, Col
    R is blank
    If a case has had a claim filed for it, Col X has the claim filed date, if
    not, Col X is blank
    If a case has been closed, Col S has the closed Date, if not, Col S is Blank.

    Each case can have one or more, or none of these dates.

    How can I get a count of how many cases there are at 12/31/03 that ,have not
    been put on hold, have not been awarded, have not had a claim filed and have
    not been closed. (As of 12/31/03)

    Any help would be appreciated. Thanks


  2. #2
    Frank Kabel
    Guest

    Re: Find Count of Items with certain criteria

    Hi
    use SUMPRODUCT. See:
    http://www.xldynamic.com/source/xld.SUMPRODUCT.html

    --
    Regards
    Frank Kabel
    Frankfurt, Germany
    "Tucson Guy" <TucsonGuy@discussions.microsoft.com> schrieb im Newsbeitrag
    news:5F7AD39A-A6A8-4237-809C-4A1EB5B6ADD9@microsoft.com...
    >I have over a thousand records (Each one a legal case)
    >
    > Col I has the date the case was opened ( All cases have a "Date Opened")
    > If a Case has been "Put on Hold", Col O has the date it was "POH". If not,
    > Col O is blank
    > If a case has been "awarded" Col R has the date it was awarded. If not,
    > Col
    > R is blank
    > If a case has had a claim filed for it, Col X has the claim filed date,
    > if
    > not, Col X is blank
    > If a case has been closed, Col S has the closed Date, if not, Col S is
    > Blank.
    >
    > Each case can have one or more, or none of these dates.
    >
    > How can I get a count of how many cases there are at 12/31/03 that ,have
    > not
    > been put on hold, have not been awarded, have not had a claim filed and
    > have
    > not been closed. (As of 12/31/03)
    >
    > Any help would be appreciated. Thanks
    >




  3. #3
    Tucson Guy
    Guest

    Re: Find Count of Items with certain criteria

    Frank--Once again, you have turned me on to an Excel feature that I need to
    learn. Thank you and Happy New Year.--When do you sleep?

    "Frank Kabel" wrote:

    > Hi
    > use SUMPRODUCT. See:
    > http://www.xldynamic.com/source/xld.SUMPRODUCT.html
    >
    > --
    > Regards
    > Frank Kabel
    > Frankfurt, Germany
    > "Tucson Guy" <TucsonGuy@discussions.microsoft.com> schrieb im Newsbeitrag
    > news:5F7AD39A-A6A8-4237-809C-4A1EB5B6ADD9@microsoft.com...
    > >I have over a thousand records (Each one a legal case)
    > >
    > > Col I has the date the case was opened ( All cases have a "Date Opened")
    > > If a Case has been "Put on Hold", Col O has the date it was "POH". If not,
    > > Col O is blank
    > > If a case has been "awarded" Col R has the date it was awarded. If not,
    > > Col
    > > R is blank
    > > If a case has had a claim filed for it, Col X has the claim filed date,
    > > if
    > > not, Col X is blank
    > > If a case has been closed, Col S has the closed Date, if not, Col S is
    > > Blank.
    > >
    > > Each case can have one or more, or none of these dates.
    > >
    > > How can I get a count of how many cases there are at 12/31/03 that ,have
    > > not
    > > been put on hold, have not been awarded, have not had a claim filed and
    > > have
    > > not been closed. (As of 12/31/03)
    > >
    > > Any help would be appreciated. Thanks
    > >

    >
    >
    >


  4. #4
    Frank Kabel
    Guest

    Re: Find Count of Items with certain criteria

    Hi
    thanks for the feedback
    Re: when do you sleep: For me it's already late in the afternoon (3:10 pm)
    and the rest of yesterday's drinks slowly fade away.....

    --
    Regards
    Frank Kabel
    Frankfurt, Germany
    "Tucson Guy" <TucsonGuy@discussions.microsoft.com> schrieb im Newsbeitrag
    news:23EDF5E4-9671-46F2-8562-AEE76D2BCC3D@microsoft.com...
    > Frank--Once again, you have turned me on to an Excel feature that I need
    > to
    > learn. Thank you and Happy New Year.--When do you sleep?
    >
    > "Frank Kabel" wrote:
    >
    >> Hi
    >> use SUMPRODUCT. See:
    >> http://www.xldynamic.com/source/xld.SUMPRODUCT.html
    >>
    >> --
    >> Regards
    >> Frank Kabel
    >> Frankfurt, Germany
    >> "Tucson Guy" <TucsonGuy@discussions.microsoft.com> schrieb im Newsbeitrag
    >> news:5F7AD39A-A6A8-4237-809C-4A1EB5B6ADD9@microsoft.com...
    >> >I have over a thousand records (Each one a legal case)
    >> >
    >> > Col I has the date the case was opened ( All cases have a "Date
    >> > Opened")
    >> > If a Case has been "Put on Hold", Col O has the date it was "POH". If
    >> > not,
    >> > Col O is blank
    >> > If a case has been "awarded" Col R has the date it was awarded. If not,
    >> > Col
    >> > R is blank
    >> > If a case has had a claim filed for it, Col X has the claim filed
    >> > date,
    >> > if
    >> > not, Col X is blank
    >> > If a case has been closed, Col S has the closed Date, if not, Col S is
    >> > Blank.
    >> >
    >> > Each case can have one or more, or none of these dates.
    >> >
    >> > How can I get a count of how many cases there are at 12/31/03 that
    >> > ,have
    >> > not
    >> > been put on hold, have not been awarded, have not had a claim filed
    >> > and
    >> > have
    >> > not been closed. (As of 12/31/03)
    >> >
    >> > Any help would be appreciated. Thanks
    >> >

    >>
    >>
    >>




+ 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