Figuring out the right funtion

[abistricer]

I amhaving an issue coming up with an accurate formula for the situation i have below: i have 3 categories 0-20,21-45 and 46-65. i have another two columnssaying where the patient is coming from (Hospital, LCHSA or outpatient) and theamount of hours are required per pateint.
I am looking for a formula to automatically tell me how many patients havehours in one of the 3 options.

such as in Hospital under 0-20 I would like to automatically put in 2 under the category seeing that there are 3 hospitals with 2 patients with hours of 0-20 and 1 patient in hospital under 21-45<o></o>
thank you for your help!!

Place of patient	Patient hours			0-20	21-45	46-65
Hospital	1		Hospital
LCHSA	15		LCHSA
Outpatient	8		Outpatient
Hospital	40
Hospital	15
LCHSA	13
LCHSA	45
Outpatient	38

<tbody>
</tbody>

<o></o>

 

[mgirvin]

Formulas in cells E3:G5. Formula in E3 and copy down and over: =COUNTIFS(Place_of_patient,$D3,Patient_hours,">="&E$1,Patient_hours,"<="&E$2)

Place of patient	Patient hours			0	21	46
Hospital	1			20	45	65
LCHSA	2		Hospital	4	5	3
Outpatient	8		LCHSA	8	3	5
Hospital	20		Outpatient	2	2	4
Hospital	15
LCHSA	13
LCHSA	18
Outpatient	20
LCHSA	13
Hospital	24
LCHSA	34
Outpatient	64
Hospital	61
Hospital	53
LCHSA	5
LCHSA	52
Outpatient	52
LCHSA	4
Hospital	29
LCHSA	5
Outpatient	63
Hospital	13
Hospital	29
LCHSA	58
LCHSA	55
Outpatient	58
LCHSA	61
Hospital	25
LCHSA	45
Outpatient	43
Hospital	58
Hospital	30
LCHSA	47
LCHSA	26
Outpatient	22
LCHSA	11

<tbody>
</tbody>

 

[mgirvin]

Or, Formula in E2 and copy through range E2:G4:

=COUNTIFS(Place_of_patient,$D2,Patient_hours,">="&LEFT(E$1,SEARCH("-",E$1)-1),Patient_hours,"<="&REPLACE(E$1,1,SEARCH("-",E$1),""))

Place of patient	Patient hours			0-20	21-45	46-65
Hospital	1		Hospital	4	5	3
LCHSA	2		LCHSA	8	3	5
Outpatient	8		Outpatient	2	2	4
Hospital	20
Hospital	15
LCHSA	13
LCHSA	18
Outpatient	20
LCHSA	13
Hospital	24
LCHSA	34
Outpatient	64
Hospital	61
Hospital	53
LCHSA	5
LCHSA	52
Outpatient	52
LCHSA	4
Hospital	29
LCHSA	5
Outpatient	63
Hospital	13
Hospital	29
LCHSA	58
LCHSA	55
Outpatient	58
LCHSA	61
Hospital	25
LCHSA	45
Outpatient	43
Hospital	58
Hospital	30
LCHSA	47
LCHSA	26
Outpatient	22
LCHSA	11

<tbody>
</tbody>