SUMPRODUCT formula in Excel | Excel Tricks & Tips
To create the formula using our sample list above, type SUMPRODUCT(C2:C5,D2:D5) and press Enter. Each cell in column C is multiplied by its corresponding cell in the same row in column D, and the results are added up.