Instead, the function must be typed into aworksheetcell.
This is the location where the function results will display.
The answer5appears in cellB7.

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.

