Use DCOUNT or DAVERAGE.

In cell F7, enter a database function to count the total number of early admissions with >= threshold scores. Use the criteria in cells K6:L7 in your function.

In cell F8, enter a database function to count the total number of in-state early admissions. Use cell references from the Criteria range in your function.

Enter database functions to calculate the average SAT (cell G7) and GPA (cell H7) for all early admits with admissions scores at or above the threshold. Note that you cannot merely average the existing averages because the counts are different for Early Admits and Regular Admits. You can use the database function without performing an advanced filter with an output range (use cell references from the Criteria range in your function).

File Home Insert Draw Page Layout Formulas Data Review view Power Pivot 9 Tell me what you want to do cut AutoSum A A Wrap Text Gene Ee copy Fill ?E EE Merge & Center s %8 Condition Format as Cell Insert Delete Format Sort & Find & B I U Format pa Clear Filter Select Formatting Table Styl Clipboard Alignment Numb diting West Coast University Admissions Office Applications for Fall 2015 Admission Criteria ry Data Residence Score Final Decision e GPA Standards & Filter 15 Last first Residence SAT GBA Admit Early RejectEary Score final Decision 7 Alevy 2300 4.0 No 4700 arly Admissi 8 Carrigg In State 2300 4,00 Yes 4700 arty Admissio 9 Ethridge Mary In State 2300 4.00 Yes 4700 No ary Admissio 20 M Bridgette In State 2245 4.00 Yes, No 4645 arty Admissio In State 2010 4.00 Yes, No 4410 arly Admissio 22 Dikun Robi Out State 3,70 No 4105 Reject 23 Gallagher Kevin In State 3.93 No Reject 24 Weatherly Kenneth In State 675 4.00 No 4075 Reject 25 Lache Michelle In State Reject 26 Blackbur In State 2000 Reject 27 DeGroat Scott In State Reject 28 Wiklendt Dan In State Reject 29 Morel ndra In State Reject 30 Hagele Michael In Stat Reject 31 Owens Mary Out State 1600 Reject elsher In State Reject 33 Rhodes, Out State 547 3.88 No 3755 Reject 34 Wat Eric Out Stat 3.59 3754 Applicants share