Sumifs cross reference multiple criteria

jjanusz

Hello,

I have a sheet where I am trying to reference multiple criteria from another sheet. For example I am looking for a count of Patient Fall with Injuries from a specific site. My formula is coming up as an incorrect argument. Any ideas on what I am doing wrong?

=SUMIFS({AOD Master Patient Care Events template Range 3}, {AOD Master Patient Care Events template Range 2}, ="Parkridge", {AOD Master Patient Care Events template Range 1}, ="CODE")

Paul Newcome

{AOD Master Patient Care Events template Range 3}

 

What kind of data is this and what type of column is it in?

jjanusz

This is patient data from a hospital. The data has all patient data such as falls, RRT's, Trauma, etc. The other column has all the hospitals in our company, but I am only looking for one of the hospitals. So essentially I am trying to write an argument that will only show one condition (such as an RRT) for only one hospital.

 

Paul Newcome

I mean that specific range? Range 3? 

jjanusz

It is the entire sheet the criterion is on.

Paul Newcome

This would be the issue then. You would need to shrink that particular range down to one column. If that column is something other than numbers, you will need to use a COUNTIFS instead of a SUMIFS in which case the syntax would be slightly different.

jjanusz

Looks like I will need to use the Countifs then. I changed it and now I am getting invalid reference.

 

=COUNTIFS({{AOD Master Patient Care Events template Range 4}, ="Parkridge", {AOD Master Patient Care Events template Range 1}, ="AMA")

jjanusz

I finally got it! Thanks for your help! 

 

=COUNTIFS({AOD Master Patient Care Events template Range 4}, "Parkridge", {AOD Master Patient Care Events template Range 1}, "AMA")

Paul Newcome

Happy to help!