Sumifs cross reference multiple criteria
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")
Comments
-
{AOD Master Patient Care Events template Range 3}
What kind of data is this and what type of column is it in?
-
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.
-
I mean that specific range? Range 3?
-
It is the entire sheet the criterion is on.
-
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.
-
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")
-
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")
-
Help Article Resources
Categories
Check out the Formula Handbook template!
