On the StudentData worksheet, in cell E5, add a COUNTIF function to count the Teacher field in the Student_Data table that meets the filter criteria in cell E4. Copy the formula through cell I5. In cell K5, add a DCOUNTA function to count the StudentID field in the Student_Data table that meets the filter criteria in the range D1:K2.

In cell K8, add a VLOOKUP function nested in an IFERROR function to retrieve the price per hour, located in column 3 in the Lesson_Pricing named range, for each student on the basis of the students skill level, located in the Skill level field. The value should be looking for an exact match. To prevent an error from being displayed when the skill level is not known, use the IFERROR function to leave the cell blank. Copy the formula through cell K94.

Price Per Hour Instrument Piano TeacherCompetition?Uniform SizePermission Slip Student SinceLevel Yes Jenny Chuck Mark Anne Debbie Total Teacher Total Students No Yes Yes Yes Yes Yes Jenny XEE NO Last NameInstrument White Piano Brock Drums Clements Viola Boyer Bass Burton Trumpet Sweeney Drums Ortiz Trumbone Ward Guitar Ward Viola Waters Drums Lee Violin Valenzuela Violin Schmidt Oboe Kline Guitar Maddox Trumbone Lambert Cello Hardin Viola Meyer Piano Pickett Drums Marshall Cello Berger Guitar Stanley Guitar Serrano Piano Miller Flute Hayden Violin Harvey Drums Burgess Clarinet Sanchez Guitar Caldwell Tuba Summers Guitar Kirk Piano Haley Cello Solomon Trumbone Yates Piano Sexton Viola TeacherCompetition? Uniform SizePermission Slip Student SinceSkill level Price Per Hour Jenny Yes XL 7/8/2015 Advanced Chuck Yes Yes 2/18/2018Intermediate Chuck Yes Yes 11/4/2015Intermediate Chuck No 12/29/2015 Mark No 7/13/2014Expert Anne Yes 7/9/2017Beginner Chuck No Yes 6/9/2016Expert Chuck Yes 11/7/2015 Advanced Mark 5/30/2015 Jenny Yes XL 11/29/2017 Advanced Jenny XXL 11/27/2014 Expert 4/6/2016 Jenny XS 10/20/2017Beginner Jenny 3/28/2016 Expert Jenny 3/12/2017Expert Jenny Yes Yes 4/4/2016Beginner Anne No 3/14/2018Intermediate Chuck Yes XXL Yes 5/28/2015Expert Mark No XS No 6/17/2016Beginner Jenny Yes XL Yes 1/3/2015 Jenny XXL 2/6/2016 Chuck Yes 1/3/2015Intermediate Chuck XXL 6/1/2018Beginner Anne No XXL Yes 12/29/2017 Advanced Chuck Yes 9/24/2015 Advanced Chuck XXL 12/19/2014Beginner Debbie No XXL 11/18/2016 Anne Yes Yes 5/24/2015 Advanced Mark No 10/12/2017 Advanced Jenny No Yes 12/19/2017Expert Debbie No XXL 6/20/2018Expert Mark 5/10/2017 Advanced Chuck Yes No 3/7/2015 Beginner Mark 2/22/2018 Expert Jenny No 9/1/2016 Intermediate No Yes No Yes No Yes Price Per Hour Instrument Piano TeacherCompetition?Uniform SizePermission Slip Student SinceLevel Yes Jenny Chuck Mark Anne Debbie Total Teacher Total Students No Yes Yes Yes Yes Yes Jenny XEE NO Last NameInstrument White Piano Brock Drums Clements Viola Boyer Bass Burton Trumpet Sweeney Drums Ortiz Trumbone Ward Guitar Ward Viola Waters Drums Lee Violin Valenzuela Violin Schmidt Oboe Kline Guitar Maddox Trumbone Lambert Cello Hardin Viola Meyer Piano Pickett Drums Marshall Cello Berger Guitar Stanley Guitar Serrano Piano Miller Flute Hayden Violin Harvey Drums Burgess Clarinet Sanchez Guitar Caldwell Tuba Summers Guitar Kirk Piano Haley Cello Solomon Trumbone Yates Piano Sexton Viola TeacherCompetition? Uniform SizePermission Slip Student SinceSkill level Price Per Hour Jenny Yes XL 7/8/2015 Advanced Chuck Yes Yes 2/18/2018Intermediate Chuck Yes Yes 11/4/2015Intermediate Chuck No 12/29/2015 Mark No 7/13/2014Expert Anne Yes 7/9/2017Beginner Chuck No Yes 6/9/2016Expert Chuck Yes 11/7/2015 Advanced Mark 5/30/2015 Jenny Yes XL 11/29/2017 Advanced Jenny XXL 11/27/2014 Expert 4/6/2016 Jenny XS 10/20/2017Beginner Jenny 3/28/2016 Expert Jenny 3/12/2017Expert Jenny Yes Yes 4/4/2016Beginner Anne No 3/14/2018Intermediate Chuck Yes XXL Yes 5/28/2015Expert Mark No XS No 6/17/2016Beginner Jenny Yes XL Yes 1/3/2015 Jenny XXL 2/6/2016 Chuck Yes 1/3/2015Intermediate Chuck XXL 6/1/2018Beginner Anne No XXL Yes 12/29/2017 Advanced Chuck Yes 9/24/2015 Advanced Chuck XXL 12/19/2014Beginner Debbie No XXL 11/18/2016 Anne Yes Yes 5/24/2015 Advanced Mark No 10/12/2017 Advanced Jenny No Yes 12/19/2017Expert Debbie No XXL 6/20/2018Expert Mark 5/10/2017 Advanced Chuck Yes No 3/7/2015 Beginner Mark 2/22/2018 Expert Jenny No 9/1/2016 Intermediate No Yes No Yes No Yes