Convert Array Formula to work in macro?

[eblake]

I have the following Array Formula in a spreadsheet, the same basic formula is used for 8 columns by 30 rows, if theres only one sheet recalculating it is quick, but there are 15-30 sheets like this. Is it possible to make a macro get the answer to the formula and put it on the page to cut down on calculation time?

{=SUM(IF(Data!$D$2:$D$9984=$D$10,IF(Data!$B$2:$B$9984=$B13,Data!$E$2:$E$9984,0),0))}

Thanks in advance.

 

[Aladin Akyurek]

How about an ordinary SumIf formula that you can have by spending some cell space?

 

[eblake]

Unfortunately that puts the calculations back on the spreadsheet. I'm hoping to generate the answer through a macro rather than a formula.

Thanks for the suggestion.

 

[Juan Pablo González]

Answer = Evaluate("SUM(IF(Data!$D$2:$D$9984=$D$10,IF(Data!$B$2:$B$9984=$B13,Data!$E$2:$E$9984,0),0))")