Need 1 macros Replace function Sumif

[Excelpromax123]

Need 1 macros Replace function Sumif
Since the data is close to 40,000 . Using Sumif formula takes 1 minute. Thank

Loading Google Sheets

 

[Fluff]

Duplicate to: Code to accumulate quantity if the same name

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.