Finding Distinct Cost Codes And Totalling the amount For Each

[paul_carron]

Hi,

I have a spreadsheet with an amount column(F) and a cost code column(I).

I would like to create some sort of formula that will find all distinct cost codes and list them in another part of my worksheet and sum the amounts for that cost code and place this in the cell beside it. Is this possible and if so how do I go about doing it?

Regards
Paul

[Ace_XL]

Use pivot tables..

http://www.cpearson.com/excel/pivots.htm

[paul_carron]

Cheers Ace.

One more thing. Is it possible to exclude specific rows within that range?

[Ace_XL]

On the pivot table you could de-select (by unchecking) specific cost codes. Is that what you need?

[paul_carron]

Perfect. Thanks!