having cells add into one cell

[colman]

Hey guys-
I have two columns with A companies and B prices.
A B
AT&T 3
AT&T 5
AT&T 1
AT&T 1

What I want is to have there just be one row that has A- AT&T and B-10 (sum of the prices)

I have 380 rows and lots of duplicates so I dont want to do all this manually.

Any help?

 

[bolandd]

Have a look at subtotals under the data section.

 

[colman]

Im still confused on how to do it

 

[EYEMDABEST]

If you created a pivot table from your data and used column A of the work sheet in the Row field of the pivot table and column B of the worksheet as the data section and make it "Sum" of B then you would get the result you are looking for.