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")

Find more posts tagged with

Healthcare

Formulas

Support

Comments

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!

Sign in to join the conversation!

Quick Links

Trending discussions

Lookup Value Issues
I am trying to populate a column from Sheet A into Sheet B and Sheet C. My Lookup column for Sheet A is formatted as such so there is a ' in front to account for ones that have a leading 0 and some do not. Each ID should be 6 digits long. I made a helper column looking at this Dealer ID column to try and get rid of that…
Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.