Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
where can I find a sample home inventory that list all items i ma. | Excel Discussion (Misc queries) | |||
How do I find out what items are in one list but not in another l. | Excel Discussion (Misc queries) | |||
Counting With Blank Rows | Excel Discussion (Misc queries) | |||
boolean find criteria in Excel | Excel Discussion (Misc queries) | |||
Find duplicates | Excel Discussion (Misc queries) |