Question: Question: 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

Question: 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

Question: 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.

Please help. The Class_IDs named range is cells B4:H4 on the data worksheet, and the ClassNames named range is cells B11:H11 on the data worksheet. There is also a named range called "Jazzercise", which I'm not sure is relevant. The final answer should be "2". PLEASE only submit the formula if the answer comes out to "2" in cell B12. This makes sense as "Jill" and "Joe" are the only instructors that teach J49. Thank you.

Home Insert Draw Page Layout Formulas Data Review View Automate Q Tell me Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Home Insert Draw Page Layout Formulas Data Review View Automate Q Tell me Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Instructors \begin{tabular}{|c|c|c|c|c|c|c|} \hline Zumba_I & Jazzercise_I & Yoga_I & Step_Aeroblcs_I & Swimmerclze_I & Aeroblcs_I & Tal_Chl_I \\ \hline Joe & Joe & Shanti & Joe & Francine & Joe & Shanti \\ \hline Jill & Jill & & Bill & Jill & Bill & \\ \hline Alesha & & & & & Alesha & \\ \hline \end{tabular}

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 Databases Questions!

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...

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...

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...

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...

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...

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 that...

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...

ach 1 1 The instructors for eclass are listed on the Data worksheet in range B 1 2 :H 1 4 . The f x | = COUNTA ( INDIRECT ( INDEX ( ClassNames , , MATCH ( A 4 , Class _ IDs, 0 ) ) , ) ) instructors...

1. What is the relationship between physical infrastructure and services as described in this case study? 2. What is the relationship between regulatory considerations and wireless services? 3. In...

For 2008, Orchard Corporation reported after-tax net income of $5,800,000. During the year, the number of shares of stock outstanding remained constant at 10,000 of $100 par, 9 percent preferred...

Welp Cost - based trancler prices that include a normal markup to the costs act as a surrogate for: Multiple Choice negotiated market prices. opportunity costs. differential costs. market prices.

On 1 March 2007 DB Limited issued R560 000 15% debentures at R98. The debentures were to be redeemed at par in four equal annual payments starting 28 February 2010. Required: Journalise the above...