I have this formula that I'm trying to put in code, but is not reading
properly to show it is an array ... how would I add the array to handle that
part of the formula?


my code:

Worksheets("Sheet2").Range("b3").Formula = _

"=SUM((Sheet1!B2:B250=""WARRANT"")*(Sheet1!F2:F250 =""E"")*(Sheet1!C2:C250))"