SExcel Question

Brain not working on Friday.

I have a spreadsheet that among other things contains a column of component part numbers, and a column of quantities.

I’d like to get the total quantities of each component. What do I need to stick in the Total Qty column to get it to calculate?

http://www.nyspeed.com/forums/attachment.php?attachmentid=10859&stc=1&d=1256306749

It is a much larger list, but the attached gives a simple example of what I’m talking about.

I can do it very manually, but I’d rather not.

Why not just make a pivot table with component and sum of quantity?

Word. Pivot table.

x3

That is what my brain couldn’t remember this morning… pivoting.