Debug Run ut Formulas Share Tools Window use the Vicekup function in eo * logicandreference.uo Dodynnarshall Data Review View Assignment Assignment Tasks Conditional Use the SUMIF function in cell 117 to determine the total number of free throws made 7 by students with brown eyes Be sure to build a formulacan be reused by copying down. 13 points) free throw.contest before tonight's game to give away free shirts. They have recorded the each participant shootsten free throws. The hair and eye color groups with the highest get at shirt. Complete the summary tables below to determine which groups made the ale to determine which students shirt How many students will shit? e Throw Get Shirt? Hair Color Summary Count 9 Brown Red Blond 9 1 7 8 7 2 Eye Color Summary Count Sum Average Brown Blue Hazel Green 9 6 How many students will get a shirt? 10 8 0 6 4 4 6 0 stion Lookup Functions Conditional Functions Average: 5.3 Count: 601 Sum: 1590 mach so values in 9018 nood to be sorted in ascending order wi Probably better just to add an entry for a quantity of 1. 2 answers MAN a 4 ABRU Insert Drew Page Layout lagicandreference-vo-Dadyrarthall Assignment Tell me Home Formulas Data Review View Bem View po Instruction to Sheet Guide 79 L M N The athletic department is sponsoring a free throw contest before tonight's game to away free sturt. They have recorded the hair and eye color of each participant. Each partit shootstenfreethews. The hand eyes with the highest werper number of free throws made will complete the many table below to dine which groups made the mote th Them complete the table to determine which shirt How many dents with Hair Color Summary Count Sum Average Black Brown Hed Blond 10 11 12 13 14 15 16 17 Eye Color Summer Count Sum Average Blue Inael Green Student Marcellor Eye Color Free Throw Get Shirt? 1 Brown Green 2 Brown 4 1 Brown Brown 9 4 Black Broen 9 5 Brown Blue 1 6 Black Blue 7 7 Brown 8 Brown Blue 7 9 Back Brown 2 10 Red 8 18 Brown 12 Back Brown 6 13 Brown Green 30 14 Black Brown 8 15 Brown Blue 16 Brown Het 6 17 Black Brown 4 18 Black 4 19 Brown 20 Blond Blue 21 Back Bro 2 Brown Brown 23 8 24 Red Harel 1 25 Blond Blue 5 16 Black Green Boch How many students will get a shirt? 24 ARARANAZAHARRRRR 34 Ready MacBook Pro esc