Scripting Dictionary for Sumif Statement

[sriley5]

Hi,

I have a large data set and using a sumif formula take a while (4-5 Minutes) is there any chance this can be done via a scripting dictionary?

[gue2013]

I added the macro to your file. I added a reference to "Microsoft Scriping Runtime"

Please Login or Register  to view this content.

[maras_mak]

Check this code.

Please Login or Register  to view this content.

[sriley5]

Gue2013 - I get a user defined error when trying to declare the new Dictionary

[sriley5]

Maras_Mak - Works like a charm! Thank you!

[gue2013]

you most probably forgot to add the reference to "Microsoft Scriping Runtime"