SUMPRODUCT

The SUMPRODUCT function is a versatile function that multiplies ranges or arrays together and outputs values that are the sum of the products. It is important to note that this function treats non-numeric items in arrays as zeros and all array arguments must be the same size.