Question: The instructors for each class are listed on the Data worksheet in range B 1 2 :H 1 4 . The instructors for the class

The instructors for each class are listed on the Data worksheet in range B12:H14. The instructors for the class in cell A4 need to be counted.
In cell B12, create a complex function that will determine the number of instructors for the class listed in A4. 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.
I can't figure out the final formula, I should be getting 2 as the answer but it just keeps getting returned as 1
The instructors for each class are listed on the

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

Q:

8 14 The instructors for each class are listed on the Data worksheet in range B12:H14. The instructors for the class in cell A4 need to be counted. In cell B12, create a complex function that will...

Q:

need help on these excel steps please. an exact matcn. Lopy ine tormula down tnrougn ceil E1Ur 8 On the Report worksheet, creale calculations that will help hotel employees manage the 10 fitness...

Q:

1. The instructors for each class are listed on the Data worksheet in range B12:H14. The instructors for the class in cell A4 need to be counted. In cell B12, create a complex function that will...

Q:

excel help The instructors for each class are listed on the Data worksheet in range B12:H14. The instructors for the class in cell A4 need to be counted. In cell B12, create a complex function that...

Q:

1 1 The instructors for each class are listed on the Data worksheet in range B 1 2 :H 1 4 . The instructors for the class in cell A 4 need to be counted. In cell B 1 2 , create a complex function...

Q:

1 1 The instructors for each class are listed on the Data worksheet in range B 1 2 :H 1 4 . The instructors for the class in cell A 4 need to be counted. In cell B 1 2 , create a complex function...

Q:

1 1 The instructors for each class are listed on the Data worksheet in range B 1 2 :H 1 4 . The instructors for the class in cell A 4 need to be counted. In cell B 1 2 , create a complex function...

Q:

1 1 The instructors for each class are listed on the Data worksheet in range B 1 2 :H 1 4 . The instructors for the class in cell A 4 need to be counted. In cell B 1 2 , create a complex function...

Q:

on fomulas and name manager i miss same named ranges ( Yoga_I, criteria) please i need your help. BEFOR, GOING TO STEP \#9 Go to Fomulas and Name Manager, Make sure your Named Ranges are like the...

Q:

please i need your help with number 14 and 15 only. e hotel has started faciltating fitness classes for hotel guests. Guests can register for classes belore their arrival or whan they armie the hotel...

Q:

In a study of women science majors, the following data were obtained on two groups, those who left their profession within a few months after graduation (leavers) and those who remained in their...

Q:

Aerobic Lifestyles Inc. manufactures stationary bicycles and rowing machines. The products are produced in the Fabrication and Assembly production departments. In addition to production activities,...

Q:

The interest rate charged on loans from the Federal Reserve to banks is commonly referred to as thea. federal funds rate. b . repo rate.c . Secured Overnight Financing Rate ( SOFR ) . d . primary...

Q:

A stock has an expected rate of return of 13.5%. The rate of return for this stock is 9% if the state of the economy is recession, 14% if the state of the economy is normal, and 18% if the state of...