COUNTIFS with multiple criteria

[kidiowa]

Hi guys, newbie here with a question. I have a spread sheet I'm using to pull medication data (I'm an Informatics RN) about meds effectiveness that is charted <30 minutes and >120 minutes after administration. I use this formula to pull the numbers for our ICU unit:

=COUNTIFS('PRN Total'!A:A,"ICU*",'PRN Total'!$E:$E,">120")+COUNTIFS('PRN Total'!A:A,"ICU*",'PRN Total'!$E:$E,"")

My problem is this. We recently broke our ICU unit into a stepdown unit (Progressive Care Unit), and want to pull the same type of numbers in the above formula within that formula (combining ICU and PCU together). The numbers for the PCU will count in the same ICU data set on another page. I tried adding

+COUNTIFS('PRN Total'!A:A,"PROGRESSIVE*",'PRN Total'!$E:$E,">120")+COUNTIFS('PRN Total'!A:A,"PROGRESSIVE*",'PRN Total'!$E:$E,"")

at the end of the first formula but keep getting an error message. Does anyone know of a way to get a count of meds that meet these criteria?

 

[jmthompson]

What error are you getting?

 

[kidiowa]

It just shows part of the formula in the cell, i've tried other way and will get the #VALUE! error, but I think that one was due to fat fingers mistyping. is there something special I need to put in between the two formulas within the cell to combine their findings?