PLEASE USE EXCEL FORMULAS FOR THE ANSWERS!

-- Formula Bar Split Normal Page Break Page Custom Zoom 100% Zoom to New Arrange Freeze Hide Switch Macros Window Headings Selection Window All PanesUnhide Neset Window Macros x 137.2 Trans # Name Date ProductUnits Dollars 4/1/2013 lip gloss 3/10/2013 foundation 2/25/2014 lipstick 5/22/2015 lip gloss 6/17/2013 lip gloss 11/27/2014 eye liner 3/21/2013 eye liner 12/17/2015 lip gloss 7/5/2015 eye liner 8/7/2015 lip gloss 11/29/2013 mascara 11/18/2013 lip gloss 8/31/2014 lip gloss 1/1/2014 eye liner 4 517201. Use SUMIF(s), COUNTIF(s), AVERAGEIF(s) to obtain the following informa 50 $152.01 2 Hallagan 3 Ashley 4 Hallagan 5 Zaret 6 Colleen 7 Cristina 8 Colleen 9 Ashley 10 Betsy 11 Ashley 12 Ashley 13 Emilee 14 Hallagan 15 Zaret 16 Emilee 17 Colleen 18 Jen 19 Jen 20 Zaret 9 $28.72 SS $167.08 43 $130.60 58 $175.99 Total number of returned lipstick Number of transactions sold by Jen or Ashley Average units foundation sold per transaction by Zaret when units more than 40 8 $25.80 72 $21784 2. Use SUMIF and DATA VALIDATION to dynamically show the total $ sold 75 $226.64 by any picked sales person. 24 $73.50 43 $130.84 23 $71.03 49 $149.59 18 556.47 8 $21.99 45 $137.39 66 $199.65 88 $265.19 78 $236.15 57 $173.12 12 $38.08 28 $86.51 25 $77.3 29 $8822 Name Total Hallagan Ashley 9/20/2015 foundation 4/12/2013 mascara 4/30/2015 mascara 8/31/2014 lip gloss 10/27/2013 eye liner 11/27/2014 lip gloss 6/2/2015 mascara 9/24/2013 eye liner Emilee 22 Betsy 24 Hallagan 25 Jen 26 Emilee 5/2/2014 foundation 11/7/2013 mascara 12/6/2015 lip gloss 4 $9.94 QIDrugCompany Q2D stances, Q. MakeupSales )