I have three columns with a cost code, description, and amount such as listed
below.

071.300 Waterproofing Systems $1,000
071.300 Waterproofing Systems $1,000
071.420 Hot Fluid-Applied Water $1,000
074.110 Metal Roof Panels $1,000
074.110 Metal Roof Panels $1,000

I would like to sum and consolidate the amounts for each cost code so that I
do not have duplicates.

Such as with the above list I would like it to show:
071.300 Waterproofing Systems $2,000
071.420 Hot Fluid-Applied Water $1,000
074.110 Metal Roof Panels $2,000

What is the best way to accomplish this?

I would use a pivottable.

If you've never used pivottables, here are a few links:

Debra Dalgleish's pictures at Jon Peltier's site:
http://peltiertech.com/Excel/Pivots/pivottables.htm
And Debra's own site:
http://www.contextures.com/xlPivot01.html

John Walkenbach also has some at:
http://j-walk.com/ss/excel/files/general.htm
(look for Tony Gwynn's Hit Database)

Chip Pearson keeps Harald Staff's notes at:
http://www.cpearson.com/excel/pivots.htm

MS has some at (xl2000 and xl2002):
http://office.microsoft.com/downloads/2000/XCrtPiv.aspx
http://office.microsoft.com/assistan...lconPT101.aspx

evoxfan wrote:
>
> I have three columns with a cost code, description, and amount such as listed
> below.
>
> 071.300 Waterproofing Systems $1,000
> 071.300 Waterproofing Systems $1,000
> 071.420 Hot Fluid-Applied Water $1,000
> 074.110 Metal Roof Panels $1,000
> 074.110 Metal Roof Panels $1,000
>
> I would like to sum and consolidate the amounts for each cost code so that I
> do not have duplicates.
>
> Such as with the above list I would like it to show:
> 071.300 Waterproofing Systems $2,000
> 071.420 Hot Fluid-Applied Water $1,000
> 074.110 Metal Roof Panels $2,000
>
> What is the best way to accomplish this?

--

Dave Peterson