I am trying to do a mutiple critera search. If I were using a function it
would either look like this:

=SUM(IF((Markups!A1:A169=C75)*(Markups!B1:B169=X75 )*(Markups!D1:D169=AR75),Markups!E1:E169,0))

or

=INDEX(Markups!$E$2:$E$320,MATCH(AR75,IF(Markups!$ A$2:$A$320=Actuals!C75,Markups!$D$2:$D$320),0))

I've tried to create a custom function to put the formula in the active cell
with no luck.

ActiveCell.FormulaArray =
"=SUM(IF((Markups!A1:A169=C74)*(Markups!B1:B169=X7 4)*(Markups!D1:D169=AR74),Markups!E1:E169,0))"

(In case you are asking why I am using a custom function for a perfectly
good existing function, it's because the custom function evaulates variables
passed and performs a different multiple criteria search based on that).

Any help would be appreciated!