Tools Excel Windows Windows - Excel Functions It is a sum of product of 2 array elements. The function supports matrices (ranges): =SUMPRODUCT(UNARY_PERCENT($D$3:$D$23)*E3:E23)