$11$ The instructors for each class are listed on the Data worksheet in range B$12$:H$14.$ The

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.