SUMIFS batch macro slow
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am trying to replicate an Excel SUMIF calculating Half Year To Date revenue by product.
There are three criteria:
- Product
- Month > Prior half
- 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
Solved! Go to Solution.
- Labels:
- Macros
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
