77-420 · Question #2
Formula. Count the number of 0 homework scores for each student. Cell range F7:F29.
Use function COUNTIF. Range: all possible homework scores for each student on 'Section 3' worksheet. Criteria: 0. Step 1: Click cell F7, and then click the Insert Function Button. Step 2: In the Insert Function dialog box, select Category Statistical, select function COUNTIF, and
Question
Explanation
Use function COUNTIF. Range: all possible homework scores for each student on 'Section 3' worksheet. Criteria: 0. Step 1: Click cell F7, and then click the Insert Function Button. Step 2: In the Insert Function dialog box, select Category Statistical, select function COUNTIF, and click OK. Step 3: Click on the Section 3 tab (left bottom part of the window). Step 4: Locate the data for the first student. This will be cell range C2 to N2. Click C2 and then Shift-click cell N2. Press Enter. Step 5: In the Function Arguments Dialog box, in the Criteria field, type: 0. Then click the OK button. Step 6: Copy cell F7 downwards until cell F29.
Topics
Community Discussion
No community discussion yet for this question.