1.00 Point: XL Activity 8.13: Using the SUMIF Function SIMS Share fx Autosum File Home Insert Page Layout Formulas Data 12 Logical 13 Lookup & Reference Recently Used - Text @ Math & Trig Insert Function Financial - Date & Time - More Functions Function Library AB_SalesBy Employee - Excel Review View Tell me what you want to do... Define Name - - Trace Precedents Use in Formula Trace Dependents Name Manager Create from Selection Remove Arrows - Defined Names Formula Auding ba Watch Window Calculation En Options Calculation G3 for E H I J K L M N In cell G3, enter a SUMIF function to calculate the weekly sales for each . C3:C102 as the Range, cell F3 as the Criteria, and D3:D102 as the Sum_range. Make the ranges C3:C102 and D3:D102 absolute. 4 Sun A B D 1 Sales Totals - Week of July 22nd 2 Weekday Type Employee ID Sales Totals 3 Sun New Customers EID1230ALI 2,600.71 Existing Customers EID1230ALI 2,682.33 5 Sun New Customers EID1230CAR 2.578.45 New Customers EID1230HUG 2,608.13 7 New Customers EID1230MER 1,933.03 Existing Customers EID1230BRY 1,678.69 9 Sun New Customers EID1230BRY 2.796.24 New Customers EID1230TOD 2.404.86 New Customers EID1230MAY 2,395.43 New Customers EID1230MAG 2,244.54 Existing Customers EID1230JAK 2,032 34 Existing Customers EID1230JER 1,268.45 New Customers EID1230JER 1,504.23 16 Mon Existing Customers EID1230RHE 1,524.81 New Customers EID1230RHE 1.320.76 Existing Customers EID1230CAR 2,200.03 New Customers EID1230CAR 1,892.10 20 Mon Existing Customers EID1230MER 1,884.68 New Customers EID1230MER 1.765.96 Existing Customers EID1230BRY 2,337.52 New Customers EID1230BRY 2,328 36 Existing Customers EID1230TOD 2,181 69 New Customers EID1230MAY 1,975.43 Existing Customers EID1230MAG 1,232.93 New Customers EID1230JAK 1,462.11 Existing Customers EID1230JER 1,599.01 20 CIAOSAD Sales Totals + 6 Sun $ Sun 10 Sun 11 Sun 12 Sun 13 Sun 14 Sun 15 Sun F Total Sales by Employee Employee ID Weekly Sales EID1230ALI EID1230ART EID1230BRY EID1230CAR EID1230HUG EID1230.JAK EID1230JAN EID1230JER EID1230JOS EID1230JUS EID1230LEX EID1230MAR EID1230MAG EID1230MAY EID1230MER EID1230RHE EID1230TOD 17 Mon 18 Mon 19 Mon 26 of 45 > 21 Mon 22 Mon 23 Mon 24 Mon 25 Mon 26 Mon 27 Mon 28 Tue Attempts Rernaining: 4 E View All C Reset Save Submit 1.00 Point: XL Activity 8.13: Using the SUMIF Function SIMS Share fx Autosum File Home Insert Page Layout Formulas Data 12 Logical 13 Lookup & Reference Recently Used - Text @ Math & Trig Insert Function Financial - Date & Time - More Functions Function Library AB_SalesBy Employee - Excel Review View Tell me what you want to do... Define Name - - Trace Precedents Use in Formula Trace Dependents Name Manager Create from Selection Remove Arrows - Defined Names Formula Auding ba Watch Window Calculation En Options Calculation G3 for E H I J K L M N In cell G3, enter a SUMIF function to calculate the weekly sales for each . C3:C102 as the Range, cell F3 as the Criteria, and D3:D102 as the Sum_range. Make the ranges C3:C102 and D3:D102 absolute. 4 Sun A B D 1 Sales Totals - Week of July 22nd 2 Weekday Type Employee ID Sales Totals 3 Sun New Customers EID1230ALI 2,600.71 Existing Customers EID1230ALI 2,682.33 5 Sun New Customers EID1230CAR 2.578.45 New Customers EID1230HUG 2,608.13 7 New Customers EID1230MER 1,933.03 Existing Customers EID1230BRY 1,678.69 9 Sun New Customers EID1230BRY 2.796.24 New Customers EID1230TOD 2.404.86 New Customers EID1230MAY 2,395.43 New Customers EID1230MAG 2,244.54 Existing Customers EID1230JAK 2,032 34 Existing Customers EID1230JER 1,268.45 New Customers EID1230JER 1,504.23 16 Mon Existing Customers EID1230RHE 1,524.81 New Customers EID1230RHE 1.320.76 Existing Customers EID1230CAR 2,200.03 New Customers EID1230CAR 1,892.10 20 Mon Existing Customers EID1230MER 1,884.68 New Customers EID1230MER 1.765.96 Existing Customers EID1230BRY 2,337.52 New Customers EID1230BRY 2,328 36 Existing Customers EID1230TOD 2,181 69 New Customers EID1230MAY 1,975.43 Existing Customers EID1230MAG 1,232.93 New Customers EID1230JAK 1,462.11 Existing Customers EID1230JER 1,599.01 20 CIAOSAD Sales Totals + 6 Sun $ Sun 10 Sun 11 Sun 12 Sun 13 Sun 14 Sun 15 Sun F Total Sales by Employee Employee ID Weekly Sales EID1230ALI EID1230ART EID1230BRY EID1230CAR EID1230HUG EID1230.JAK EID1230JAN EID1230JER EID1230JOS EID1230JUS EID1230LEX EID1230MAR EID1230MAG EID1230MAY EID1230MER EID1230RHE EID1230TOD 17 Mon 18 Mon 19 Mon 26 of 45 > 21 Mon 22 Mon 23 Mon 24 Mon 25 Mon 26 Mon 27 Mon 28 Tue Attempts Rernaining: 4 E View All C Reset Save Submit