Sum multiple lookup_values occurences

[BigHat]

The sheet I'm using has part numbers in column A, sub-part numbers in column B and costs in column C. The same part number may be listed 5 times along with multiple sub-part numbers. I would like to do a VLOOKUP (or maybe I need to use some other function) of the total costs for each part number, but when I do VLOOKUP it just gives me the cost for the first part number in the list.

Example:

A - B - C
CPU- Monitor- $3.00
CPU- Mouse- $1.00
CPU- Keyboard $5.00

I want to get $9.00, not $3.00.

[NBVC]

Try SUMIF instead.

Eg.

If your VLOOKUP was =VLOOKUP(X1,B:C,2,FALSE), then your SUMIF would be =SUMIF(B:B,X1,C:C)

[BigHat]

Thanks! Got it.