excel SUMPRODUCT function Using SUMPRODUCT with numeric ranges
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
