Code to accumulate quantity if the same name

[Excelpromax123]

Hello everyone. I need 1 piece of code to accumulate the number if the same name. Currently my data is about 20,000 lines, using sumif function is very heavy. Thanks to everyone for help. Sincerely thank

Loading Google Sheets

 

[Fluff]

How about

=sumifs(C:I,B:H,K5)

 

[Excelpromax123]

How about

=sumifs(C:I,B:H,K5)

Currently my data is about 20,000 lines, I am currently using the sumif function as above, which is very heavy. I need an array of code to run as fast as possible. Please help with the VBA code. Note the result = TABLE 1 + TABLE 2 - TABLE 3

 

[Fluff]

Sumifs for the data you have shown will not be "heavy" and if you wanted a macro why did you not say that?

 

[Excelpromax123]

Currently my data is about 20,000 lines, I am currently using the sumif function as above, which is very heavy. I need an array of code to run as fast as possible. Please help with the VBA code. Note the result = TABLE 1 + TABLE 2 - TABLE 3

I made it clear in the question title. Hope you can help

 

[Fluff]

Code does not mean a macro, a lot of people refer to a formula as code.

Hopefully someone else will provide a macro.