seaching for items ans summing them

P

peter terry

Hi guys,

I need a little help with a worksheet. I currently have a table that
contains part numbers and quantities in the format:-

part quantity

abc 125
efg 500
hjk 250

and so on.


I need to be able to search for each unique part number,sum the quantity for
each part number and display in a table. any ideas?
 
B

bj

if the part numbers are in column A and the quantities
are in column B rows 2 to 50 you can use
sumif(a2:a50,"abc",b2:50) for the sum of items called abc.
Put in a new equation for each part number.
If there are a lot of part numbers, probably a pivot
table would work better.
 
P

peter terry

Thanks for the pointer bj. There are a LOT of part numbers. Excuse my
ignorance, buts what's a pivot table?
 
D

Dave Peterson

If you've ever sorted your data and done data|subtotals to get a summary of your
data, you'll find data|pivottable a quick way of summarizing numeric data.

There is a small learning curve. Once you get by that, you'll wonder how you
ever lived without them.

Here are a few links.

Debra Dalgleish's pictures at Jon Peltier's site:
http://www.geocities.com/jonpeltier/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/assistance/2002/articles/xlconPT101.aspx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top