Sumifs with a Match

[Mac1512]

Hi All
I am trying to use a formula to sup the total Qty of Aged Stock into certain buckets 0-0.5 months / 0.5-1 etc.

I have cobbled together a formula but the values do not add up, Is there a better way to do this?

=SUMIFS(INDEX($C$5:$C$10,,MATCH(A16,$A$5:$A$10,0)),$B$5:$B$10,">"&B16,$B$5:$B$10,"<"&C16)

<tbody>
</tbody>

Data
Product	Stock Age (Months)	Qty
A	0.3	50
A	0.4	100
A	1.5	599
B	1.5	50
B	0.4	100
B	0.8	599

<colgroup><col><col><col></colgroup><tbody>
</tbody>

Product	Age From	Age To	Qty
A	0	0.5	250
A	0.5001	1	599
A	1	2	649

<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>

*Formula is the Qty box e.g 250

 

[Scott T]

Excel 2010
	A	B	C	D
1	Product	Stock Age (Months)	Qty
2	A	0.3	50
3	A	0.4	100
4	A	1.5	599
5	B	1.5	50
6	B	0.4	100
7	B	0.8	599
8
9
10	A	0	0.5	250
11	A	0.5001	1	599
12	A	1	2	649
13
14	if you need it by product
15	A	0	0.5	150
16	A	0.5001	1	0
17	A	1	2	599
18	B	0	0.5	100
19	B	0.5001	1	599
20	B	1	2	50
Sheet4

Cell Formulas
Range	Formula
D10	=SUMIFS($C$2:$C$7,$B$2:$B$7,">"&B10,$B$2:$B$7,"<"&C10)

 

[Mac1512]

Excellent Thanks - How do I see the Fromula you have in D15 that returns 150 (Yes it is by product I need it)