SUMIFS With Multiple Criteria In One Column

[jski21]

Good day,

Using the following formula with success:

=SUMIFS(PSData!$J:$J,PSData!$K:$K,">=4/1/2024",PSData!$K:$K,"<=4/30/2024",PSData!$E:$E,"=RES602782",PSData!$Q:$Q,"=HCM")

However, I've found to truly get it accurate in terms of pulling in the right data, I need to have the data in Column E:E pull in "RES602782" AND "RES602497".

How best to add this to the formula or do I need to go in another direction?


Thanks!


jski

 

[Fluff]

How about

=sumproduct(SUMIFS(PSData!$J:$J,PSData!$K:$K,">=4/1/2024",PSData!$K:$K,"<=4/30/2024",PSData!$E:$E,"{RES602782","RES602497"},PSData!$Q:$Q,"=HCM"))

 

[jski21]

Thanks. Getting an error at RES602497?

=sumproduct(SUMIFS(PSData!$J:$J,PSData!$K:$K,">=4/1/2024",PSData!$K:$K,"<=4/30/2024",PSData!$E:$E,"{RES602782","RES602497"},PSData!$Q:$Q,"=HCM"))

 

[Sergius]

Change

"{RES602782", "RES602497" }

on

{"RES602782", "RES602497" }

 

[jski21]

That did it. Thanks Fluff and Sergius. Here's the final solution for the record:

=SUMPRODUCT (SUMIFS (PSData!$J:$J, PSData!$K:$K,">=4/1/2024", PSData!$K:$K,"<=4/30/2024",PSData!$E:$E, {"RES602782","RES602497"}, PSData!$Q:$Q, "=HCM"))

 

[Fluff]

Glad we could help & thanks for the feedback.