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

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

On Tue, 29 Jun 2010 06:39:44 -0700 (PDT), "(E-Mail Removed)"
<(E-Mail Removed)> wrote:

>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

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.

On Jun 29, 9:39*pm, "bwot...@gmail.com" <bwot...@gmail.com> wrote:
> 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