Hi Kevin,

I want to know is there any formula to find in sheet 1, column A the sum of reapeated company names as a text, return to column B and find out the sum of all materials supplied by the same company name again as a text, and the sume of those related material cost in column C.

Ex,

A B C
Blum Hinge 12
Richelue Sandpaper .55
Wonder paint 125
bibi Plywood 56
Nadi Screw 200
Bobi Nail 100
Blum Hinge 34
Wonder Paint 324
Nadi Screw 650
Richelue Sandpaper 25
Wonder Paint 34
bibi Plywood 342

Thanks, Iraj.