student listed in cell B2 . The value should be looking for
an exact match.
9
In cell B6, use the COUNTIF function to count the
StudentID field on the Lesson Data worksheet that
meet the filter criteria in cell
B2
.
In cell B7, use the SUMIF function to sum the Total Fee
field on the Lesson Data worksheet that meet the filter
criteria in cell B2 .
In cell B8, use a nested IF function to determine how
many free lessons the student has earned (shown as
Total Lessons in cell B6). If the student has had less
10