Data Look Up

[bwottle]

Hi All,

I need some help with acquiring some data from a spreadsheet. I have a
spreadsheet that has a list of part numbers repeated throughout the
data. As well there are other columns of information that are
associated to these parts numbers.

An example is part # 123456 is repeated, has a date next to each
entry, as well as a dollar amount. What I'm trying to accomplish is to
do a lookup of all the part numbers, and get a total of the dollar
amount for each.

When I use the Vlookup function, I simply get the last entry in the
sheet, and that corresponding dollar amount. Is there a way to get a
total of the dollars amounts for part number 123456?

Thanks,
Brian

 

[Gord Dibben]

Method 1

=SUMIF(A1:A100,"# 123456",C1:C100)

Method 2

Sort all data by part numbers then use Data>Subtotal on each change of part
number.

Method 3

Create a Pivot Table.


Gord Dibben MS Excel MVP

 

[Max]

Use a pivot, fast n easy. Put the "Part#" col header into ROW area,
the "Amt" col header into DATA area (it'll auto-set to SUM), click to
finish the wizard. That's it. The pivot returns a col listing of all
the unique Part#s and their corresponding sum of Amts next to it.