VBA Calculation Performance HELP

[Ferrugem]

Dear developers,

I have created a VBA application to process commissions and would like your feedback on how I can improve the performance on calculations on 20,000 rows of data. For instance, to calculate product margin I have used application.WorsheetFunction.SumIfs. Below is an image of my code. Has anyone done something similar to this in a more efficient way? Thanks

 

[sheetspread]

Sumifs is usually too slow for 20,000 rows, try a pivot table instead.