4 Sun 8 Sun 9 Sun Sales Totals - Week of July 22nd Total Sales by Employee 1 2 Weekday Type Employee ID Sales Totals Employee ID Weekly Sales 3 Sun INew Customers EID1230ALI 2,600.71 EID1230ALI Existing Customers EID1230ALI 2.682.33 EID1230ART 5 Sun New Customers EID1230CAR 2,578 45 EID1230BRY 6 Sun New Customers EID1230HUG 2,608.13 EID1230CAR 7 Sun New Customers EID1230MER 1,938,03 EID1230HUG Existing Customers EID1230BRY 1,678 69 EID1230JAK New Customers EID1230BRY 2,796 24 ED1230JAN 10 Sun New Customers EID1230TOD 2.404 86 EID1230JER New Customers EID1230MAY 2,395.43 EID1230JOS New Customers EID1230MAG 2,244 54 EID1230JUS Existing Customers EID1230JAK 2,032 34 EID1230LEX Sales Totals Ready Ask me anything 1.00 Point XL Activity 8.13: Using the SUMIF Function In cell G3, enter a SUMIF function to calculate the weekly sales for each employee. Use 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. 11 Sun 12 Sun 13 Sun GH