excel Using SUMPRODUCT with numeric ranges


Example

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

enter image description here

=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