Sum Excel columns

Question

I need to make a loop, for each Code I must have only one row

Here I share with you more details of the formula

Answer 1

Use this excel function:

Then click within your table and click on subtotal. The below window will display. Then set the criteria as you want.