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

SUMIF Macro.yxmc

Example sumif.xlsx

Qiu

@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.

0927-allanallan.yxzp