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

Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
Countifs result not matching filter
In my sheet, I have a filter for 2 values (see below images). The result is 294 In my report this formula yields 304. =COUNTIFS({helper-child}, "1", {gapStatus}, <>"Rejected (not a GAP)", {gapStatus}, <>"removed - duplicate", {gapStatus}, <>"removed - not valid") Why are they not matching? What am I missing?
Using CONTAINS in a MAX(COLLECT) function
I have a schedule that has a task name column, a date column and a task type column. I am trying to build a formula (in another sheet) that will return the latest date based on when the task type is "APP" and the task name contains "GS" somewhere in the cell. Here is the formula I have come up with: MAX(COLLECT({Schedule…