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