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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 12:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com