sumifs condition multiple not blank cells

[ivill]

Jim	10	30	1
Kate	20	40	3
Green	30	50	5
Red	40	60	7
Bill	50	70	9
Jim	60	80	11
Green	70	90	13
Karry	80	100	15
Beth	90	110	17
Forte	100	120	19
JIM

=SUMIFS(D1:D10,A1:A10,A11,B1:B10,">0")
The result should be 12
How do i define "or" condition in the SUMIFS formula?
B1:B10,">0" or C1:C10,">0"
if B1 <=0, C1 >0, The result should still be the same as 12

 

[Fluff]

That formula does return 12 for me

+Fluff 1.xlsm
	A	B	C	D
1	Jim	10	30	1
2	Kate	20	40	3
3	Green	30	50	5
4	Red	40	60	7
5	Bill	50	70	9
6	Jim	60	80	11
7	Green	70	90	13
8	Karry	80	100	15
9	Beth	90	110	17
10	Forte	100	120	19
11	JIM	12
Main

Cell Formulas
Range	Formula
B11	B11	=SUMIFS(D1:D10,A1:A10,A11,B1:B10,">0")

 

[ivill]

That formula does return 12 for me

+Fluff 1.xlsm
	A	B	C	D
1	Jim	10	30	1
2	Kate	20	40	3
3	Green	30	50	5
4	Red	40	60	7
5	Bill	50	70	9
6	Jim	60	80	11
7	Green	70	90	13
8	Karry	80	100	15
9	Beth	90	110	17
10	Forte	100	120	19
11	JIM	12
Main

Cell Formulas
Range	Formula
B11	B11	=SUMIFS(D1:D10,A1:A10,A11,B1:B10,">0")

I'm sorry i should be more clear, but.. my english is worse...
right now, The B1:B10 is the criteria_range2
can i define OR condition? i.e. B1:B10 OR C1:C10

 

[Fluff]

How about

=SUMPRODUCT((A1:A10=A11)*(((B1:B10>0)+(C1:C10>0))>0)*(D1:D10))

 

[ivill]

How about

=SUMPRODUCT((A1:A10=A11)*(((B1:B10>0)+(C1:C10>0))>0)*(D1:D10))

calc.xlsm
	A	B	C	D	E
1	Name	Item1	Item2	Qty1	Qty2
2	JIM	1	0	1	50
3	KATE	11	10	3	50
4	GREEN	21	20	5	50
5	RED	31	30	7	50
6	BILL	41	40	9	50
7	JIM	51	50	11	60
8	GREEN	61	60	13	50
9	KARRY	71	70	15	50
10	BETH	81	80	17	50
11	FORTE	91	90	19	50
12
13	JIM	Total	12
14
15	The condition is Qty2 >=60
16	And The result should be 11(Sum_range)
17	How to use SUMIFS with The =SUMPRODUCT((A2:A11=A13)*(((B2:B11>0)+(C2:C11>0))>0)*(D2:D11)) to get the result?
2

Cell Formulas
Range	Formula
B3:C11	B3	=B2+10
D3:D11	D3	=D2+2
C13	C13	=SUMPRODUCT((A2:A11=A13)*(((B2:B11>0)+(C2:C11>0))>0)*(D2:D11))

here is another further question, I'm sorry, i'm not sure how to adjust the mini sheet, please check the sheet, How to use SUMIFS with The =SUMPRODUCT((A2:A11=A13)*(((B2:B11>0)+(C2:C11>0))>0)*(D2:D11)) to get the result?

 

[Fluff]

How about

=SUMPRODUCT((A2:A11=A13)*(((B2:B11>0)+(C2:C11>0))>0)*(E2:E11>=60)*(D2:D11))

 

[ivill]

How about

=SUMPRODUCT((A2:A11=A13)*(((B2:B11>0)+(C2:C11>0))>0)*(E2:E11>=60)*(D2:D11))

This expression formula is very useful, thanks very much sir

 

[Fluff]

You're welcome & thanks for the feedback.