SUMIFS batch macro slow

[allanallan]

I am trying to replicate an Excel SUMIF calculating Half Year To Date revenue by product.

There are three criteria:

1. Product
2. Month > Prior half
3. Month <= Month

I have created the attached macro using examples posted on this forum, however for a dataset of ~40,000 records it is taking over half an hour to complete when Excel can do this almost instantly.

Is there something that can be done to speed this up?

 

Thanks

[PangHC]

based on your excel, i believe you can use running total tool instead. 

here the configuration. 

workflow: sort first ensure the month is ascending

sample result.

[Qiu · Accepted solution]

@allanallan 
I dont see how is much time consumed for this flow.

I am sorry but it seems that you are not using the macro correct to minic the Sumif function.

A quick sample for your reference.