Question: In cell B7, add a SUMIF function to sum the Total Fee field on the LessonData worksheet that meets the filter criteria in cell B2.

In cell B7, add a SUMIF function to sum the Total

In cell B7, add a SUMIF function to sum the Total Fee field on the LessonData worksheet that meets the filter criteria in cell B2. In cell B8, add a two nested IF function to determine how many free lessons the student has earned. If the student has had fewer than 5 total lessons, display 0 earned. If the student has had between 5 and 10 lessons display 1 earned . otherwise display 7 earned

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

Working on Excel project y,XL,CH05_PS2_AS-Lessons 1.4. Problem #9 In cell B7, add a SUMIF function to sum the Total Fee field on the LessonData worksheet that meets the filter criteria in cell B2. In...

AutoSave OFF G Sv e : W YOExcel16Ch05PS2v2_Instructions - Saved to my Mac Q Search in Document Home Insert Draw Design Layout References Mailings Review View Comments Share Aabbccdder v Evv at...

I need help with the last four steps of this excel homework. Steps 13, 14, 15, and 16. YO_Excel16_Ch05_PS2_v2 Project Description: A local music studio, Fiddlers, has a large number of clients who...

Start Excel. Open the downloaded Excel file named e03ch05_grader_a1_Lessons.xlsx . Save the file with the name e03ch05_grader_a1_Lessons_LastFirst replacing LastFirst with your last and first name....

Lesson_Pricing as the name. Select the range A13.E17, and then create a named range using Trans_Fees as the name. Select the range A20:G24, and then create a named range using Uniform_Fees as the...

PROJECT STEPS Darius Beckman is the service manager for SmartEnergy Services in Tampa, Florida. The company provides electrical energy equipment and services to cities and other organizations. In an...

Darius Beckman is the service manager for SmartEnergy Services in Tampa, Florida. The company provides electrical energy equipment and services to cities and other organizations. In an Excel...

Start Excel. Open the downloaded Excel file named 203ch05_grader_al_Lessons.xlsx. Save the file with the name e03ch05_grader_a1_Lessons_Last.First replacing LastFirst with your last and first name....

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

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

After deciding to close one of its middle schools, the Springfield school board needs to reassign all of next years middle school students to the three remaining middle schools. Many of the students...

Construct an appropriate chart to show the proportion of funds in each investment category in the Excel file Retirement Portfolio.

You have just purchased a brand new bicycle for your 5 - year - old daughter. You want her to know and understand each of the bicycle's parts, including the training wheels. Which of the following is...

Rattigan Company?s income statement contained the condensed information below. Rattigan?s balance sheet contained the comparative data at December 31, shown below. Accounts payable pertain to...

Professional ethics and end-of-year actions. Janet Taylor is the new division controller of the snack-foods division of Gourmet Foods. Gourmet Foods has reported a minimum 15% growth in annual...

Mathias Company manufactures a number of specialized machine parts. Part B unkka-22 uses $35 of direct materials and $15 of direct labor per unit. Mathias?? estimated manufacturing overhead is as...

An analysis of the transactions made by Mark Kotsay & Co., a certified public accounting firm, for the month of August is shown below. The expenses were $650 for rent, $4,800 for salaries and wages,...

Software-procurement decision, ethics. Jorge Michaels is the Chicago-based controller of Fiesta Foods, a rapidly growing manufacturer and marketer of Mexican food products. Michaels is currently...

Tori and some other childeen experimented with balls to see which ones rolled. First using a piece of cardboard to use as a ramp, they angled it on a block to the floor to test the balls. Then Tori...

What is the difference between a copyright and a trademark? Between a trademark and a brand? LO.1

List and briefly explain the laws that protect people in the workplace. LO.1

What licenses are required by the owner of a small business? LO.1