excel Using SUMPRODUCT with numeric ranges


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

enter image description here


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