using Uniform_Fees as the name. Select the range
D3:F4, and then create a named range using
Entry_Fee as the name.
4
Click the Student Data worksheet tab. In cells E5:I5,
count the number of students assigned to each teacher:
in cell E5, use the COUNTIF function to count the
Teacher field in the Student_Data table that meets the
filter criteria in cell E4 .
Copy the formula in cell E5 over to cell I5.
In cell K5, use the DCOUNTA function to count the
StudentID field in the Student_Data table that meets
the filter criteria in the range D1:K2.
8