You will use an array formula to do this, which means you must hit
CTL+Shift+Enter when you are done inputting it instead of just Enter. For
COST-TOM the formula
=SUM(IF($A$7:$A$10&$B$7:$B$10=$B$1&$A2,$C$7:$C$10) )
this assumes your data available begins in A7 and product end in B10. For
COST-Harry the formula would be
=SUM(IF($A$7:$A$10&$B$7:$B$10=$C$1&$A2,$C$7:$C$10) )
if you don't see {} around your formula when you are done you didn't hit
CTL+Shift+Enter.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Nimish Shah" wrote:

Dear Sir,

I am in seacrh of a formula. I want to fill up the cell of COST-TOm and
COST-Harry.

Product COST-TOM COST-Harry
Apple ??? ???
Mango ??? ???
Banana ??? ???

Data Available
Farmer Product COST
Tom Apple 10
Harry Apple 20
Harry Banana 7
Tom Apple 10
Harry Mango 30
Harry Apple 20
Tom Mango 15
Harry Mango 30

Regards,
Nimish