=COUNTIF($A$2:$A$500,D2)

replace the cells with the dollar signs with the actual range of your sheet
and cell range for the part numbers, then D2 is the first cell with a part
number, copy down as long as needed


--
Regards,

Peo Sjoblom



"Amber" wrote in message
...
I have a document with a list of part numbers and quantities. I would like
to create a function that allows me to update a new sheet where all the
part
numbers are listed. I would like it to show how many of a certain part
number show up on the sheet calculating the quantity with in the line.
With
the example below, I would like to answer the question: How many Part 1's
have been sold? This should be 6.

Part 1 2
Part 2 3
Part 3 1
Part 1 4