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?
[TABLE="width: 613"]
<tbody>[TR]
[TD="width: 613"]=SUMIFS(INDEX($C$5:$C$10,,MATCH(A16,$A$5:$A$10,0)),$B$5:$B$10,">"&B16,$B$5:$B$10,"<"&C16)[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 256"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Data[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Product[/TD]
[TD]Stock Age (Months)[/TD]
[TD]Qty[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD="align: right"]0.3[/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD="align: right"]0.4[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD="align: right"]1.5[/TD]
[TD="align: right"]599[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD="align: right"]1.5[/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD="align: right"]0.4[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD="align: right"]0.8[/TD]
[TD="align: right"]599[/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 320"]
<colgroup><col><col><col span="2"></colgroup><tbody>[TR]
[TD]Product[/TD]
[TD]Age From[/TD]
[TD]Age To[/TD]
[TD]Qty[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: right"]250[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD="align: right"]0.5001[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]599[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]649[/TD]
[/TR]
</tbody>[/TABLE]
*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)