SUMIFS Multiple "OR" Criteria

[NicholasP]

I have a formula where I'm trying to use multiple criteria in an "OR" manner

=SUM(SUMIFS('Sheet1'!$R:$R,'Sheet1'!$K:$K,"Govt",'Sheet1'!I:I,{"Apple","Orange"},'Sheet1'!$O:$O,{"ONE","TWO","THREE"}))

So the idea is to sum if:
column K = Govt
Column I = Apple or Orange
Column O = One or Two or Three

I feel like I'm close, but

 

[Joe4]

As per the instructions here (Excel formula: SUMIFS with multiple criteria and OR logic | Exceljet), you need to use semi-colons in the last array, i.e.
=SUM(SUMIFS('Sheet1'!$R:$R,'Sheet1'!$K:$K,"Govt",'Sheet1'!I:I,{"Apple","Orange"},'Sheet1'!$O:$O,{"ONE";"TWO";"THREE"}))
and be sure to enter with CTL+SHIFT+ENTER

 

[NicholasP]

Thank you for responding and thanks for providing the link as well. I was not aware that you need to use semi-colons in the last array.

Thanks again
Nick

 

[Joe4]

I was not aware that you need to use semi-colons in the last array.

I wasn't either, so it was a learning experience for me as well!

 

[Eric W]

You don't need the CTRL-SHIFT-ENTER if you use explicit array variables (like {"Apple","Orange"}), but if you use a name (Range1) or range (A1:A5) then you do.