CountsIFs Between Range of Values, SUM Adjacent Column

[revocats10]

I need a formula to lookup / COUNTIF the values in Column A, based on a condition
of being between a range greater than 0 and less than 50. Then SUM the values in the adjacent Column (Column B), for only the rows in Column A that match the criteria.
I tried doing like the formula below, but i can't get it to work
>==COUNTIFS(A:A,">0", A:A,"<50"),SUM(B:B). In the attached image of the spreadsheet, the correct total would = 32
I can do this manually but this is just an example, I need to work with a much larger list and also update the criteria range and then repeat for multiple other spreadsheets
Thanks for any assistance.

 

[Fluff]

How about

+Fluff New.xlsm
	A	B	C	D	E
1
2	0	15	Min value	0	32
3	1	3	Max value	50
4	4	2
5	10	5
6	20	6
7	35	11
8	48	5
9	50	6
10	60	4
11	75	10
12	85	3
Main

Cell Formulas
Range	Formula
E2	E2	=SUMPRODUCT((A2:A12>D2)*(A2:A12<D3),B2:B12)

 

[jasonb75]

Why not just use sumifs?

=SUMIFS(B:B,A:A,">0",A:A,"<50")

 

[revocats10]

Thanks for the

Why not just use sumifs?

=SUMIFS(B:B,A:A,">0",A:A,"<50")

This worked. I don't experience doing compound formulas like this as I usually will do things in stages so I really appreciate your help. thanks very much!

 

[revocats10]

How about

+Fluff New.xlsm
	A	B	C	D	E
1
2	0	15	Min value	0	32
3	1	3	Max value	50
4	4	2
5	10	5
6	20	6
7	35	11
8	48	5
9	50	6
10	60	4
11	75	10
12	85	3
Main

Cell Formulas
Range	Formula
E2	E2	=SUMPRODUCT((A2:A12>D2)*(A2:A12<D3),B2:B12)

this gave me a value = 0. The second post worked. Thanks.