Thank you sir. I have solved my problem. I have learnt Pivot Tables and this
is really wonderful and woks faster then typing manually all the formulas.

Regards,

Nimish



"iliace" wrote:

Pivot tables are easier to grasp than formulas, and they are certainly
easier to set up and maintain than a bunch of formulas. Why reinvent
the wheel when Excel already has a built-in feature that does what you
want perfectly?


On Dec 27, 9:56 am, Nimish Shah
wrote:
Hi Fred,

Thank you but i have never worked with Pivot Tables. Is there a formula with
IF, sumproduct etc etc. which can help. In the meantime i am trying to learn
Pivot Table.

Regards,

Nimish

"Fred Smith" wrote:
You want a pivot table. It's perfect for your application. Look here for help:
http://www.cpearson.com/excel/pivots.htm

--
Regards,
Fred

"Nimish Shah" wrote in message
...
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