1. In cell K11, create a formula using the DCOUNT function to count the number of projects with final costs of more than $100,000, using the data in the entire Projects table (Projects[#All]) and counting the values in the column of final costs ("Final Cost") that are equal to the values in the range J9:J10.
2. In cell K15, create a formula using the DCOUNTA function to count the number of projects completed in 2019, using the data in the entire Projects table (Projects[#All]) and counting the values in the column of completion dates ("Completed") that are equal to the values in the range J13:J14.

E 1 N Number 5 8 Project Type Expansion Landscape New Construction Renovation Upgrade M Total Cost Average Cost $743,687 $148,737 $510,261 $63,783 $4,292,507 $613,215 $1,183,113 $118,311 $369,037 $123,012 7 2017 $60,935 10 3 2017 2018 Final Cost >100000 Number of Projects: 2018 2019 Completed 2019 Number of Projects: 2019 A B C D 2 ID Project Name Project Type Campus 3 EX-4096 Didrikson Gymnasium Expansion La Croix 4 LA-5066 Wales Lake Landscape Hempstead 5 RE-1751 Ardmore House Renovation Hempstead 6 EX-4188 Transit Center Expansion Hempstead 7 NE-3027 Bixbury Apartments New construction Newburgh 8 LA-5104 Hempsted Field Landscape Hempstead 9 RE-1854 Sullivan Library Renovation Newburgh 10 RE-1890 Richardson Hall Renovation Newburgh 11 LA-5218 Freestone Plaza Landscape Newburgh 12 EX-4209 Boyle Residences Expansion Newburgh 13 NE-3153 Ambani International Center New construction Hempstead 14 RE-1904 Clarkson Laboratory Renovation La Croix 15 LA-5276 Alumni Center Landscape Hempstead 16 RE-1922 Founders House Renovation Hempstead 17 RE-1957 Nakamura Physics Renovation Hempstead 18 RE-1961 Grounds and Building Renovation Newburgh 19 RE-1977 Thorne Family Pavilion Renovation La Croix 20 RE-1982 121 Forest Street Renovation Hempstead 21 EX-4242 Kao Performance Center Expansion Hempstead 22 NE-3209 Whitman Child Care New construction La Croix 23 RE-1953 Riverfront Graduate Housing Renovation Hempstead 24 LA-5303 Student Commons Landscape La Croix 25 NE-3301 Politzer Center New construction Hempstead 26 NE-3387 Sills Cultural Center New construction Newburgh 27 UP-2004 Campus Electrical Upgrade Hempstead 28 LA-5355 Arts Quad Landscape Hempstead 29 UP-2033 Computing Research Upgrade Hempstead 30 NE-3412 Benton Hall of Business New construction Hempstead 31 EX-4103 Santiago Field Expansion Newburgh 32 LA-5113 Heinrich Mall Landscape Hempstead 33 NE-3045 Charles Street Entrance New construction Hempstead 34 UP-2011 Mansfield Observatory Upgrade Hempstead 35 LA-5197 Visitor's Center Landscape La Croix ac F G H Completed Budget Final Cost 2016 $213,475 $225,631 2016 $59,320 $60,600 2017 $82,500 $89,754 $62,750 2017 $689,430 $700,225 $42,500 $42,850 2018 $55,750 $56,127 $195,640 $200,326 2018 $48,700 $48,850 $109,800 $110,456 2019 $847,400 $889,325 $78,775 $79,349 2019 $78,300 $78,550 $32,500 $32,500 2019 $195,600 $199,800 2019 $78,500 2019 $52,500 $52,500 $153,200 $155,600 2019 $210,750 $220,158 2020 $285,430 $285,329 2020 $225,000 $234,657 2020 $76,500 $79,225 $750,325 $752,855 2020 $575,200 $590,568 $124,865 $154,382 2021 $83,450 $84,072 2021 $179,400 $180,055 2021 $989,500 $990,455 $124,500 $126,507 2017 $76,500 $78,024 2017 $83,750 $83,750 2018 $34,600 $34,600 $37,450 $38,090 Green Feature Materials Materials Materials Stormwater Green roof Stormwater Green roof Stormwater Stormwater Materials Green roof Stormwater Materials Solar panels Materials Stormwater Solar panels Materials Materials Solar panels Materials Materials Materials Materials Solar panels Materials Green roof Materials Solar panels Materials Materials Solar panels Stormwater $82,500 Campus Newburgh Total Cost: $1,915,559 2019 Campus Hempstead Average Cost: $232,785 2020 2021 2016 2018