Consolidate data from an excel sheet - Simple task

Job ID: 34064787

Budget: $10 – $30 USD

Hi,
I need help with Consolidation of the quantity marked in red in the excel file attached for each UPC (marked in yellow) in the Excel file attached.