9000 The average total salesperson for Austrian sa10500 9000 90007 What is the

# 9000 the average total salesperson for austrian

• MarynaB
• 9

This preview shows page 4 - 9 out of 9 pages.

€90.00 The average total salesperson for Austrian sa €105.00 €90.00 €90.00 7. What is the total number of EU nationals in the list? €105.00 €105.00 €90.00 €90.00 €90.00 €105.00 €90.00 €90.00 2. Add 'whole row' formatting for value selected in N 4 . 5a. Type the heading 'Christmas Bonus' into cell H1 . 5b. Starting in cell H2 , extract the first three digits from the Sale and look up the Basic Bonus amount on the sheet 'Christmas B All female employees get an additional flat bonus of €15 (added 6. Calculate the average Total Sales amount for the nationality s Enter a formula into cell J35 below. Show this as a complete sen e.g. The average total sales from Spanish salespersons is €465 Enter a formula into cell N38 to show the answer: 8. In cell N44 enter a formula to show the total sales amount fo SUMIFS and COUNTIFS are extended versions, they count/sum u
€105.00 €105.00 €90.00 €105.00 €95.00 €80.00 €95.00 €95.00 €80.00 €80.00 €95.00 €80.00 €95.00 €80.00 €80.00 €95.00 €95.00 €95.00 €80.00 €80.00 €95.00 €80.00 €80.00 €95.00 €80.00 €95.00 €80.00 €80.00 €80.00 €85.00 €85.00 €85.00 €85.00 €70.00 €70.00 €70.00 €70.00 €70.00 €85.00 €85.00 €70.00 €70.00 €85.00 €70.00 €70.00 €85.00 €70.00 9. Using COUNTIFS , enter a formula to show how many Austria 10. Using SUMIFS , what is the total sales for German women?
€85.00 €70.00 €85.00 €70.00 €85.00 €70.00 €85.00 €75.00
Select Nationality Austrian American ONALITY Use COUNTIF: 13 Use SUMIF: €4,082.91 ee number. s Euro. d €465.51 for the AVERAGE amount for the chosen nationality. alespersons is \$314.07. 81 \$20,210.94 esperson code Bonus'. d on to the basic bonus). shown in cell N4 . ntence with amounts formatted to 2 decimal places . 5.51. or the NORTH and EAST regions combined. using multiple AND criteria i.e. everything must be true to be included.
8 1,406.38 an Males are in the list.
CHRISTMAS BONUS Employee No Basic Bonus 001 100 025 90 050 80 075 70 100 60

#### You've reached the end of your free preview.

Want to read all 9 pages?

• Fall '15
• Ingo Feinerer
• European American, Ethnic groups in the United States, Use SUMIF, OneilDale

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern