Example
Consider the ranges A1:A3
and B1:B3
having the same size and only number values, as below

=SUMPRODUCT(A1:A3,B1:B3)
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