Find value of matching columns

[nehpets12]

What formula do I need in row 9 to find the value of matching items in column A

Example for cell "B9" 6 Apples @ £1.50 + 3 Orange @ £3.60 + 8 Pear @ £2.50 = £39.80

Book1 (2).xls
	A	B	C	D	E	F	G
1	Description	Qty	Qty	Qty		Description	Cost
2	Apple	6	1	6		Apple	1.50
3	Orange	3	2	5		Pear	2.50
4	Bread	2	3	4		Orange	3.60
5	Pear	8	4	3		Dog	4.00
6	Ham	4	5	2		Cat	23.00
7	Cheese	9	6	1		Mouse	5.50
8						Tiger	3.20
9	Value
10	ThisIsTheAnswerIWant	39.80	18.70	34.50
Sheet1

 

[Aladin Akyurek]

What formula do I need in row 9 to find the value of matching items in column A

Example for cell "B9" 6 Apples @ £1.50 + 3 Orange @ £3.60 + 8 Pear @ £2.50 = £39.80

Book1 (2).xls
	A	B	C	D	E	F	G
1	Description	Qty	Qty	Qty		Description	Cost
2	Apple	6	1	6		Apple	1.50
3	Orange	3	2	5		Pear	2.50
4	Bread	2	3	4		Orange	3.60
5	Pear	8	4	3		Dog	4.00
6	Ham	4	5	2		Cat	23.00
7	Cheese	9	6	1		Mouse	5.50
8						Tiger	3.20
9	Value
10	ThisIsTheAnswerIWant	39.80	18.70	34.50
Sheet1

B9, just enter and copy across:

=SUMPRODUCT(SUMIF($F$2:$F$8,$A$2:$A$7,$G$2:$G$8),B$2:B$7)

 

[nehpets12]

That is exactly what I want. But is it possible to move the value into the the middle of the range of data without getting the referance error?

Book1 (2).xls
	A	B	C	D	E	F	G
1	Description	Qty	Qty	Qty		Description	Cost
2	Apple	6	1	6		Apple	1.50
3	Orange	3	2	5		Pear	2.50
4	Bread	2	3	4		Orange	3.60
5	Value	0	0	0		Dog	4.00
6	Pear	8	4	3		Cat	23.00
7	Ham	4	5	2		Mouse	5.50
8	Cheese	9	6	1		Tiger	3.20
9
10
11	ThisIsTheAnswerIWant	39.80	18.70	34.50
Sheet1

Have a look at my earlier post this shows what I am tring to achieve http://www.mrexcel.com/forum/showthread.php?t=538803