Grouping of values matching criteria then summing corresponding

Hi Laura,

Here is another way of explaining my query

Trying to write a code to sum up the values in a column providing the two previous column values match up.

EG

AG AAA 123
AG AAA 321
AG CCC 456
AU AAA 252
PT AAA 322
PT AAA 111
PT BBB 333

So I want to grp all the AG&AAA's together (=444) then AG&CCC etc etc)

And I want to paste AAA into a column in new sheet alongside the total sum (444) under a heading for AG.

Hope this helps, I'd really appreciate the advice.

Linda

Hi Laura,

Don't worry, I managed to get what I wanted out of pivot table, I didn't think it would format nicely but turned out ok. I think what I was after was an array, still not entirely sure how to do it but will work it out if I need to do it again!

thanks for help
Linda