ach $11$ The instructors for eclass are listed on the Data worksheet in range B$12$:H$14.$ The$f_x|=$ COUNTA$($INDIRECT$($INDEX$($ClassNames$,,$MATCH$($A$4,$Class$\_$IDs,$0)),))$

instructors for the class in cell A$4$ need to be counted.

In cell B$12,$ create a complex function that will determine the number of instructors for the

class listed in A$4.$ Use the COUNTA, INDIRECT, INDEX, and MATCH functions. Use the

Class. IDs named range inside the MATCH function and the ClassNames named range inside

the INDEX function.A$18$

$\backslash$table$[[,$A$,$B$,$C$,$D$,$E$,$F$,$G$,H,$I$],[1],[2],[3],[4,$Class ID$,223,J49,Y23,$A$22,539,$A$39,T22,],[5,$Class Category,Zumba,Jazzercise,Yoga,Step Aerobics,Swimmercize,Aerobics,Tai Chi,$],[6,$Max Enrollment,$20,20,10,30,10,30,20,],[7,$Can Split,$Y,Y,N,Y,Y,Y,N,],[8,$Fee,$$50\mathrm{.}00,$$$35\mathrm{.}00,$$$40\mathrm{.}00,$$$25\mathrm{.}00,$$$25\mathrm{.}00,$$$30\mathrm{.}00,$$$75\mathrm{.}00,],[9],[10,,$Instructors,$],[11,,$Zumba$\_$I,Jazzercise$\_$I,Yoga$\_$I,Step$\_$Aerobics$\_$I,Swimmercize$\_$I,Aerobics$\_$I,Tai$\_$Chi$\_$I,$],[12,,$Joe,Joe,Shanti,Joe,Francine,Joe,Shanti,$],[13,,$Jill,Jill,,Bill,Jill,Bill,,$],[14,,$Alesha,,,,,Alesha,,$]]$