VLOOKUP to find sum of all duplicates

Hello,

I am trying to extract the sum of all numbers (QTY) for the same lookup_value.

PART# LOCATION QTY
ABC LA 0
ABC TX 5
ABC NY 6
ZXC LA 1
ZXC TX 5
ZXC NY 9

So I want to have, ABC showing "11" (0+5+6), and ZXC=15

Also, how do I use vlookup with a condition (IF maybe?), to do a vlookup for ABC on QTY when it is LA, for QTY when it is TX, for QTY when it is NY separately?

Thank you!

Thank you Jeffrey for your prompt response.

SUMIF/SUMIFS works great.

I thought about the pivot table; I need to extract some data like quantity, vendor, buyer, application from each part number onto another worksheet. The problem I have is that I have 13 worksheets, and each of them have 45k rows and 55 columns.

Each worksheet represents a month (the end of it), so I was thinking maybe I can record a macro of me doing a pivot table on worksheet"month1" and applying it to all the worksheets.. OR

I can put all worksheets together vertically or horizontally, and add a column/row for MONTH, and then do a pivot table that will slice through it. The other problem I will have however is that, I need two worksheets for one count of data-> Each worksheet represents values for the end of the month, so for me to find the average quantity of inventory held, I need to ADD quantity (Available) from end of month1, to quantity available from end of month2, and then divide by 2 to get somewhat my "Average" quantity of inventory for month2.

Sorry if I went on a tangent here-, maybe ill just do pivots for each worksheet and then do vlookup from pivot tables so I can calculate my average per month. Anything I do, needs to be recordable on macros, so I can apply it next month when a new end of month worksheet comes out.