Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 1st 05, 02:33 PM
Tucson Guy
 
Posts: n/a
Default 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   Report Post  
Old January 1st 05, 02:55 PM
Frank Kabel
 
Posts: n/a
Default

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

--
Regards
Frank Kabel
Frankfurt, Germany
"Tucson Guy" schrieb im Newsbeitrag
...
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   Report Post  
Old January 1st 05, 03:09 PM
Tucson Guy
 
Posts: n/a
Default

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" schrieb im Newsbeitrag
...
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   Report Post  
Old January 1st 05, 03:11 PM
Frank Kabel
 
Posts: n/a
Default

Hi
thanks for the feedback
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" schrieb im Newsbeitrag
...
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" schrieb im Newsbeitrag
...
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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
where can I find a sample home inventory that list all items i ma. lanier Excel Discussion (Misc queries) 2 December 28th 04 10:54 AM
How do I find out what items are in one list but not in another l. Michelle Craig Excel Discussion (Misc queries) 2 December 22nd 04 09:32 PM
Counting With Blank Rows SMDIYDLI Excel Discussion (Misc queries) 4 December 21st 04 10:00 AM
boolean find criteria in Excel davista00 Excel Discussion (Misc queries) 1 December 1st 04 04:45 PM
Find duplicates R. Choate Excel Discussion (Misc queries) 5 November 28th 04 11:14 PM


All times are GMT +1. The time now is 11:31 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017