The Excel SUMPRODUCT function multiplies corresponding elements in multiple arrays and then sums the products. It is used for weighted calculations, conditional aggregations, and array-based calculations in spreadsheets. www.modelsbytalias.com/excel-sumproduct-function/
