SUMIF Formula to Macro or VBA

**ZEIGLDA06** · 06-12-2015, 11:33 AM

Hey folks,
I am having a problem with an excel sheet at work. I deal with large amounts of data on a daily basis and I am sick of locking up Excel with complicated formulas. Am I correct in thinking that using a Macro rather than a Formula would speed up the process and allow me to sift through the data more efficiently? If so, I have the SUMIF formula below but I am new to the Macro scene and cannot seem to figure out how to make it work as a Macro. I am trying to add up the total uses across the country for a specific part. So i basically need to add up "Y-T-D SALES" for each part and put it into "TOTAL USES ACROSS THE COUNTRY" column Any help would be much appreciated. Thanks!!

=SUMIFS('MASTER'!E2:E14266, 'MASTER'!E2:E14266, 'DONNIE'!D2)

**gmr4evr1** · 06-12-2015, 11:59 AM

Try this for your Test2 code...

Please Login or Register  to view this content.

Edit* This will not totally take care of the issue, but might get you farther than you were.

**ZEIGLDA06** · 06-12-2015, 12:06 PM

I applied the above Macro and it looked like it was going to work, but nothing appeared in cell D2. There we no errors or anything, but nothing appeared. Maybe I am entering it wrong or something. I did and ALT-F11 to open the macro page, then pasted your formula, then hit ALT-F11 again, then ALT-F8 and ran the macro. Did I do this correctly?

**gmr4evr1** · 06-12-2015, 12:31 PM

Yes, you did it correctly. I added an edit to my original post that you may not have seen. The code I provided will only get rid of the errors you were getting, it will not display anything in column D. There needs to be more added to the code, but I'm not sure what. I was thinking an IF/Then statement. I did play with this a little bit, but didn't get anything to work....yet. I will continue to try it out as I can, unless someone else provides a solution before I do.