if. match, countif HELP!

[CHRISB37]

Help!!! I need to take the following data example and on another worksheet sum each item by pcs according to code

type pcs cases code
a1 100 10 l102bm
a2 150 15 k104bm
a3 180 18 l111bm
a1 120 12 l102bm
b2 140 14 h118bm
a1 100 10 l112mb
a3 130 13 h104bm


ie.. Result need to be----
type pcs code
a1 220 l102bm
a1 100 l112mb
a2 150 k104mb
a3 130 h104bm
a3 180 l111bm
b2 140 h118bm

i believe i need an index function to find unique values and then sum them in a sorted order.......

Any help would be greatly appreciated....

Thanks!!!!

[rscsmith]

Hi Chris

This looks like a job for PivotTables to me!

I don't know which parts of Excel you are familiar with, and I don't wish to teach you to 'suck eggs'. If you've never used PTs before, I would strongly advise learning them now you have some excellent data with which to try them. They are extremely powerful and very easy to use. The day I discovered them was a real epiphany.

If they don't do what you need, or you are struggling with them, please upload some test data so we can resolve the issue for you.

Cheers, Rob.