A SUM with a nested COUNTIFS

SUM the rows that contain these values

What are you summing?

[*]Yes, At Arrival at the ED[*]Yes, Sustained for 20 Consecutive Minutes[*]Yes, Prior to ED Arrival Only

What columns do these refer to?

I see the confusion, as the first message was chopped off

display the given "year", and SUM to total times the "Yes, At Arrival at the ED","Yes, Sustained for 20 Consecutive Minutes","Yes, Prior to ED Arrival Only" appear for the given year.

I would then repeat the formula for the next year.

I had tried a = SUM (COuntif(year,"2020",ROSC_in_Field("Yes, At Arrival at the ED","Yes, Sustained for 20 Consecutive Minutes","Yes, Prior to ED Arrival Only")))

Sum product

every sample I found online wouldn't work for me in this setup.

YEAR = named for Column C
ROSC_in_Field = named for Column AZ

Sorry for the earlier confusion

Try

Formula:

Please Login or Register  to view this content.

=SUM(COUNTIFS(Year,"2020",ROSC_in_Field,{"Yes, At Arrival at the ED","Yes, Sustained for 20 Consecutive Minutes","Yes, Prior to ED Arrival Only"}))

comes back a #REF!

I verified Year, and ROSC_in_Field

Not sure what is going on.

It works for me in your sample file, is that where you tried it?

I had tried it in the actual file.

It didn't work. I then tried the sample file, it worked there. Puzzling.

I copied it to the same worksheet as the data, not the master worksheet. It worked there. Weird

I then copied it to the same cell I had first tried. Now it works.

Can you please explain the difference between the { and the ( brackets used. As I was extremely close, just needed the different bracket. Why did it make all the difference?

Glad it's working & thanks for the feedback.

The curly braces {} signifies that you using an array of values.