were going to show you how to use SUMPRODUCT) in Excel 2016.
The SUMPRODUCT) formula is basically a combination of the SUM and PRODUCT formulas, and it takes arrays as arguments. =SUMPRODUCT(E2: 44, F2: F44)
This example will multiply E2 by F2, multiply E3 by F3, and sum them up, etc Date: 2023-07-08