Instead, the function must be typed into aworksheetcell.

This is the location where the function results will display.

The answer5appears in cellB7.

Screenshot showing tutorial data for the SUMPRODUCT function in Excel

SelectcellB7to view the completed formula in theformula barabove the worksheet.

The function then sums up all the true values to arrive at the result of 5.

Screenshot showing the completed SUMPRODUCT function in Excel

Screenshot showing the completed SUMPRODUCT function in Excel