Consider the ranges A1:A3 and B1:B3 having the same size and only number values, as below
This will loop through the ranges, taking the product of values in the same row and summing them, returning 32 in this example.
A1*B1 = 4
A2*B2 = 10
A3*B3 = 18