SUMIFS with nested OR

[rcocrane99]

I've been trying to add an OR formula within my sumifs calculation and it doesn't seem to work. below I've attached a similar function with an if statement and OR inside. Does anyone know why it returns and error??

 

[ExcelToDAX]

How about:

=SUM(SUMIFS(D:D,B:B,{"JC","RCG","Other"},C:C,"HP",A:A,H4))

 

[rcocrane99]

Yes that works! What's the difference though?

 

[Joe4]

You cannot use "OR" in the manner you tried in a SUMIFS formula.
The squiggly brackets means that the entry just needs to be one of those values listed.