Summing Items Same Items in a Mixed Column

[Izila]

Hi All,

I have a series of columns for orders on my spreadsheet. The furthest left column contains item numbers, the second column contains the quantities ordered whilst the final column contains the item names.

I'm trying to find a way whereby any items that are ordered multiple times have their quantity summed and placed next to the item name column. I have experimented with VLOOKUP and SUMIF but I've had no success.

Any help is greatly appreciated.

Thanks in advance,

Izila

 

[Izila]

Thanks again for your help JV010. Much appreciated.