COUNTIFS problem

[kidiowa]

Here's my problem. I'm using a worksheet for monitoring medication administration in our ICU. This is the formula that I'm using that works great (so far):

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

Now that we added some more wards within our ICU (PCU-S and PCU-M) the countif is not capturing the data of the PCU. I've tried adding the wildcard * in front of ICU in the above formula (ex: "*CU*") but get an error that only displays the formula. Is there an easy fix to get the formula to recognize the "CU" within these searches? No other wards have CU within their names. Any help is greatly appreciated. Thanks! Jim

 

[barry houdini]

That should work.....

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

 

[VoG]

This does not error for me

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

 

[kidiowa]

That should work.....

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

I've tried that and still got the same error. For some reason the * in front of the CU is throwing something off, can't figure it out for the life of me.