Try a Pivot Table this:

DataPivot Table
Use Excel
Select your data
Click the [Layout] button

ROW: Drag the Type field here
DATA: Drag the quantity field here
If it doesn't list as Sum of Dates...dbl-click it and set it to Sum
Click [OK]
Select where you want the Pivot Table...and you're done!

That will list each Type and the total quantity for that type.

To refresh the Pivot Table, just right click it and select Refresh Data

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Class316" wrote:


Ok, here's what I have


type quantity

a 1
a 2
b 3
b 3
b 1
c 2
c 2

I need to have:

a 3
b 7
c 4

What is the best way to do this without tedious summations and
deletions? thanks in advance!


--
Class316
------------------------------------------------------------------------
Class316's Profile: http://www.excelforum.com/member.php...o&userid=24163
View this thread: http://www.excelforum.com/showthread...hreadid=525812