Sumifs with multiple criteria and OR statement

[rcocrane99]

Hello, Im looking to add multiple values with variating criteria where there are 3 catagories, 2 locations and 5 sources example below.
The primary and secondary i have been able to complete but the other is giving me some difficulty
=sumifs(D:D,A:A,H6,C:C, Location 1 or 2,B:B,OR("D","E","F"))

 

[arun_eagertolearn]

Please try

=sumifs(D:D, A:A,H6, C:C, OR(right(I4,1)*1,right(L4,1)*1), B:B,OR("D","E","F"))

 

[rcocrane99]

Please try

=sumifs(D:D, A:A,H6, C:C, OR(right(I4,1)*1,right(L4,1)*1), B:B,OR("D","E","F"))

sorry its a little confusing posting an example and not the exact thing, my actual formula is =SUMIFS($D:$D,$A:$A,H36,$C:$C,"HP",$B:$B,OR("Other","JC","RCG")) where HP is a location and Other, JC and RCG are different sources in my other category, specifically the OR statement isnt working as a criteria and im undsure why

 

[awoohaw]

try this:
Edited to reflect your exact formula, except for column range lengths:

Book1
	A	B	C	D				H	I
35	Crit1Column	Crit3Column	Crit2Column	SumColumn				Crit1	Result:
36	2	Other	HP	20				3	49
37	3	JC	Location 2	16
38	3	G	HP	30
39	1	JC	Location 3	23
40	1	RCG	HP	16
41	1	JC	HP	28
42	3	RCG	HP	30
43	1	RCG	Location 2	19
44	2	G	Location 1	29
45	1	Other	HP	30
46	3	RCG	HP	19
47	2	G	HP	21
48	2	JC	HP	19
49	3	Other	Location 1	24
50	3	JC	Location 3	28
Sheet1

Cell Formulas
Range	Formula
I36	I36	=SUMPRODUCT(($D$36:$D$50)* ($A$36:$A$50=$H$36)* (($C$36:$C$50="HP"))* (($B$36:$B$50="Other")+($B$36:$B$50="RCG")+($B$36:$B$50="JC")))

 

[Fluff]

How about

=sum(SUMIFS($D:$D,$A:$A,H36,$C:$C,"HP",$B:$B,{"Other","JC","RCG"}))

 

[rcocrane99]

that works! thank you, may i ask why the{} instead of () and what does having the sum function surrounding it all do for this? also why was my original formula not working?

 

[Fluff]

The {} makes it an array & the sum is needed to sum all the results from the array.
Your formula didn't work as you cannot use OR like that.