using excel array functions on part of array

say I have arrays ArrA and ArrB, of lengths x and y.

I know I can write, say,

Please Login or Register  to view this content.

to get the sumproduct off the two arrays. however, say i want to sumproduct of just the first z elements of the arrays. is there a neat way of getting this?

try something like this

Please Login or Register  to view this content.