Vlookup On Duplicate Contract Numbers & Return Price From All Contracts?

[olimits7]

Hi,

I have a spreadsheet where I have duplicate contract numbers with different prices and I'm trying to get the sum price of all these contracts.

I used a Vlookup which worked properly but it only returned the amount for 1 of contracts; is there another method I can use to return the sum of all duplicate contracts?

Thank you!

 

[R0GU3]

Try either SUMIF or SUMIFS (multiple criteria) . You could always use Index/Match but getting the sum of all the prices I would use SUMIF