How to group and calculate the amount by product name?

Question

excel

There is a table like: Product name
\ Quantity
Product 1 \ 10
Product 2 \ 20
Product 3 \ 10
Product 1 \ 5
Product 3 \ 6
Product 2 \ 30
sum. That is, group and calculate the sum.
I don’t even know how to formulate a request to Google) Maybe someone knows how this is done?

Answer 1

Or through pivot tables,
or, more simply, through autosums .
If the table is abnormal, normalize, sort (most conveniently through autofilters) by product name, set the results by autosum for each change in the product name.