In cell I26 insert a DMIN function to calculate the minimum salary of employees based on the criteria from range A25:F26 - Then in cell I27 insert a DMAX function to calculate the maximum salary of employees based on the criteria from range A25:F26 - Finally in cell I28 insert a DCOUNT function to count the number employees based on the criteria entered from range A25:F26.

Apps G MO Outlook Mall UNG HANNER DL Core Zoom El Academic catalog Pearson M Mathwwy Alger. SMS Share fx Autosum - Home Insert Page Layout Formulas Dati 12 Legea 1 Lookup & Reference Recently Used - A Text 10 Math & Trig. action ID Fianca Date & Time - 1 More Functions. Function Lwy 6078aryinformation - Excel Review View Tal me what you want to do Defne Name >> Tros Prodents 9 Usein Fonda Trace Dependents Name Mense Create from Selection Hemove Arrows. Dend Nines Fomentin Go Watch Window Calculatih Options daki 37 F H 1 K A D Salary Information Employee ID Last Name Region Title 79804428 Auker North Sales Rep 29804955 Browne Mid-West Sales Rep 79901268 Gesing East Sales Rep 79804458 Ghisu East Sales Rep 79803996 Glanton North Sales Rep 79802521 Hagarty North Sales Rep 79802698 Hoyt East Sales Rep 79801370 Hussin East Sales Rep 79801256 Kaye East Sales Rep 79804070 Keone Mid-West Sales Rep 79803099 Loing Mid-West Manager 79802848 Lorent North Sales Rep 79802611 Malatesta Mid-West Sales Rep 79802967 Pax Mid-West Sales Rep 79802645 Reiser East Sales Rep 29801781 Remoldo Mid-West Sales Rep 79802009 Scholfield East Sales Rep 79804453 Slowia North Manager 79803824 Spurrier East Manager 79804545 Terriquez Mid-West Sales Rep Salary Details Advanced Filter Hire Date 11/8/2016 $ 10/3/2017 $ 9/3/2015$ 2/19/2014 $ 2/18/2015 $ B/14/2012$ 4/15/2018 $ 9/18/2014 1$ 11/4/2015 4/3/2015 $ 1/17/2009 $ 10/15/2016 $ 8/15/2017 $ 7/4/2018 $ 6/5/2014 $ 1/31/2014 $ 7/14/2014 5 3/7/2010 $ 7/14/2006 3 4/15/2017 $ Salary 41,525 49.575 45.250 47.240 45,000 46,000 49.750 47,835 45.100 45.125 B0,500 46,725 41.000 46,795 43,750 43,750 39.750 70.800 7950 49.750 Data SIMS Sh Fle Home Insert Page Layout Formas Legal 12 Lookup & Reference Recently Used - Test I Moth & Trg - Function I Financial Date Time - More Function Function fx Anun 607 Salomon Excel Review View Tell me what you want to do Deine Name Trace Precedents the inform Trace Dependents Name Manager Create from Selection Remove Arrows- Der Name Famil Audit Calculator Watch Window Options Cake 127 E G N K A 18 79801281 Romolde 19 79802009 Schofield 20 79804453 Sowik 21 79803824 Spurrier 79804545 Terriquez 20 24 25 Employee ID Last Name 1 Mid-West East North East Mid-West D Soles Rep Sales Rep Manager Manager Sales Rop 1/31/2014 7/14/2016 3/7/2010 7/14/2006 4/15/2017 $ $ $ $ $ F 43.750 39.750 70.800 78.750 49.750 Criteria Range Title Sales Rep Hire Date Region Mid-West Salary Summary Statistics Average 5 45.999 Low High # of Employees 19 30 Employee ID Last Name 31 79804955 Browne 79804070 Keone 33 79802611 Malatesta 79802967 Pax 25 79801281 Remolde 56 79804545 Terriquez Region Mid-West Mid-West Mid-West Mid-West Mid-West Mid-West Output Range Title Sales Rep Sales Rep Sales Rep Sales Rep Sales Rep Sales Rep Hire Date 10/3/2017 $ 4/3/2015 $ 8/15/2017 7/4/2018 1/31/2014 4/15/2017 GU Salary 49.575 45.125 41.000 46.795 43.750 49.750 Saan Data Advanced Editor