Need Help with Countif or countifs

Hi,

I work for a hospital and am new to this forum. I have been able to count the number of people in the our ED at a certain hour of a certain day called the hourly census.

Census uses this forumula:
=F2-(COUNTIF(D2:D9451, "<="&H2)+COUNTIF(B2:B9451,">="&H2))
(Total # of Patients) - ((Number of patients who departed before hour x)+(Number of patients who arrived after hour x))

Now I need to know the census in the ED by Acuity. Acuity is the assigned medical emergency code we give patients at triage.

For example, I want to show the number of patients in the ED at 2AM with an acuity of 1,2,3,4, or 5.

Attached my worksheet for help.

Thanks in advance!

I've tried but it doesnt work. I get 0 with the following equation.

=COUNTIFS(D3:D9452,"<="&H3,B3:B9452,">="&H3,C3:C9452,"3 - Urgent")

SDCH, This is close but not yet correct. I put in the formula and dragged it down for one day. The total for each acuity for the day ended up being the sum of the acuities for the month.

The sum of the acuities at each hour/of each day should equal the census. For example, the census from 1/1/2013 0:00 to 1/1/2013 0:59 is 77 people. The sum of the acuities at this hour will equal 77.

Thanks in advance!

The first day works perfect. I'm going to manually count a few hours but it looks perfect.

Thanks so much alansidman!!