A Excel SUMIFS a X SUMIF With Mu X C i need help with X + X M Inbox (69) - wt X . New tab X Q course hero - S X Ask a Question X C https://www.coursehero.com/tutors/homework-help/ask/?question_id=49535126%2F#/text-check/ V JX =SUIVIIF(BIO:318,L10,G10:318) M B C DE F G H K A V Chicago Correct Cities Found! 16 ######## Chicago Kivell Hat 96 16 $ 1,535.04 CORRECT ######## Atlanta Parent Hat 74 16 $ 1,183.26 CORRECT Atlanta + Denver 3/24/2021 Chicago Jardine Hat 50 16 799.50 CORRECT 4/27/2021 Atlanta Howard Hat 96 16 $ 1,535.04 CORRECT 20 7/4/2021 Atlanta Jones Hat 62 16$ 991.38 CORRECT Item 21 7/21/2021 Chicagc Morgan Hat 55 16 $ 879.45 CORRECT Hat Correct Products Found! 22 8/7/2021 Chicago Kivell Hat 42 16 $ 671.58 CORRECT Pants 23 9/27/2021 Denver Sorvino Hat 76 16 $ 1,215.24 CORRECT Pants 30 $ 1,499.50 CORRECT Shirt 1/23/2020 Chicago Kivell 50 4/1/2020 Atlanta Jones Pants 60 30 $ 1,799.40 CORRECT socks Pants 30 $ 1,799.40 CORRECT 26 6/8/2020 Atlanta Jones 60 27 7/12/2020 Atlanta Howard Pants 29 30 $ 869.71 CORRECT 7/29/2020 Atlanta Parent Pants 81 30 $ 2,429.19 CORRECT REP NAME 28 Gall Correct Reps Found! 29 10/5/2020 Chicagc Morgan Pants 28 30 $ 839.72 CORRECT 1,379.54 CORRECT jones 30 ######## Chicago Gill Pants 46 30 $ 2/1/2021 Chicago Smith 2,609.13 CORRECT Parent Pants 87 30 $ Kivell 32 2/18/2021 Atlanta Jones Pants 30 $ 119.96 CORRECT Jardine 33 3/7/2021 Denver Sorvino Pants 30 $ 209.93 CORRECT 80 30 $ Howard 34 5/31/2021 Chicago Gill Pants 2,399.20 CORRECT 1,709.43 CORRECT Morgan 35 10/14/2021 Denver Thompson Pants 57 30 $ Sorting 36 11/17/2021 Chicago Jardine Pants 11 30 $ 329.89 CORRECT 37 12/4/2021 Chicago Jardine Pants 94 30 $ 2,819.06 CORRECT Smith Thompson 38 12/21/2021 Chicagc Andrews Pants 28 30 $ 839.72 CORRECT 39 1/6/2020 Atlanta Jones Shirt 95 20 1,899.05 CORRECT Andrews 3:57 PM X 2 46.F Q Search 3/10/2023 CloudyM Inbox (69) - wtr X New tab X Q course hero - S X Ask a Question X A Excel SUMIFS a X SUMIF With M X C i need help with X + X C https://www.coursehero.com/tutors/homework-help/ask/?question_id=49535126%2F#/text-check/ M N 0 P 1. Use UNIQUE for city in L16. There are 3 unique cities. 2. Use the SUMIF function in column N. HINT: you will check the value in L 16 against the values in B and column G. Use the Correct Cities Found! 2.334.54 |Please Try Again Fill handle so think about relative vs absolute references. Please enter the formula Please enter the formula + UNITS PER Item Use the UNIQUE function in L22. There are 4 unique ITEMS. Use the SUMIF function for Correct Products Found! Please enter the formula units per item in Column N. Please enter the formula Please enter the formula Please enter the formula SALES BY REP Use the UNIQUE function in L29. There are 11 unique rep names. Use the SUMIF function for Correct Reps Found! Please enter the formula sales by rep in Column N. Please enter the formula Use the SUMIF function for sales by rep in Column N. Please enter the formula Use the SUMIF function for sales by rep in Column N. Please enter the formula Use the SUMIF function for sales by rep in Column N. Please enter the formula Use the SUMIF function for sales by rep in Column N. Please enter the formula Use the SUMIF function for sales by rep in Column N. Please enter the formula Use the SUMIF function for sales by rep in Column N. Please enter the formula Use the SUMIF function for sales by rep in Column N. Please enter the formula Use the SUMIF function for sales by rep in Column N. Please enter the formula Use the SUMIF function for sales by rep in Column N. Please enter the formula Use the SUMIF function for sales by rep in Column N. 46.F Cloudy Q Search O 3:57 PM x 3/10/2023 2