Sorry, I might be missing something here but, if you just want a simple array function that you want to drag down, I think you'd just put:

Formula: copy to clipboard 
=$A2:$A5*$B2:$B5
committed with Ctrl-Shift-Enter rather than just Enter.

If you want to get the sum of the arrays, then you'd use:

Formula: copy to clipboard 
=SUM($A$2:$A$5*$B$2:$B$5)
committed with Ctrl-Shift-Enter rather than just Enter

or, alternatively:

Formula: copy to clipboard 
=SUMPRODUCT($A$2:$A$5*$B$2:$B$5)
. Note: this is not an Array Formula


Like I say, I might be missing something in my understanding or your requirement.


If the formula is more complex, perhaps you can share it with us.



Regards, TMS