Hi

the easiest and fastest way is to use a Pivot Table. You will need headers in each column.Select a cell somewhere in the range then Insert - Pivot Table. Drag the product to comun range and the quantities to totals.
If you need to do something else with the result, you can use the SUMIF function

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post