3. In the range 32:M7, Camille wants to summarize project information. Start by calculating the number of each project type as follows: a. In cell K3, enter a formula using the COUNTIF function that counts the number of Expansion projects, checking that the column of project types in the Projects table (Projects [Project Type]) is equal to the value in cell J3. I b. Fill the range K4:K7 with the formula in cell K3. Dakarminn roject Name Wales Lake Project Type Campus Green Feature Completed Budget Final Cost Project Type Number Total Cost Averag Landscape Hempstead Materials. 2016 $59,320 $60,600 Expansion antiago Field Expansion Newburgh Solar panels 2016 $124,500 $126,507 Landscape idrikson Gymnasium Expansion La Croix Materials 2016 $213,475 $225,631 New Construction ompsted Field Landscape Hempstead Stormwater 2017 $42,500 $42,850 Renovation ransit Center einrich Mall rdmore House Charles Street Entrance Boxbury Apartments Mansfield Observatory Visitor's Center Freestone Plaza Sullivan Library Boyle Residences Richardson Hall Expansion Hempstead Stormwater 2017 $62,750 $560,935 Upgrade Landscape Hempstead Materials 2017 $76,500 $78,024 Renovation Hempstead Materials 2017 $87,500 $89,754 Final Cost New construction Hempstead Materials 2017 $83,750 $83,750 100000 New construction Newburgh Green roof 2017 $689,430 $700,225 Number of Projects: 16 Upgrade Hempstead Solar panels 2018 $34,600 $34,600 Landscape La Croix Stormwater 2018 $37,450 $38,090 Completed Landscape Newburgh Stormwater 2018 $48,700 $48,850 2019 Renovation Newburgh Green roof 2018 $55,750 $56,127 Number of Projects: 9 Expansion Newburgh Materials 2018 $109,800 $110,456 Renovation Newburgh Stormwater 2018 $195,640 $200,326 Campus Founders House Renovation Hempstead Solar panels 2019 $32,500 $32,500 Newburgh Thorne Family Pavilion Renovation. Alumni Center Landscape Grounds and Building 1 Renovation Clarkson Laboratory 121 Forest Street Renovation La Croix Hempstead Newburgh La Croix Solar panels 2019 $52,500 $52,500 Total Cost: $1,915,559 Materials 2019 $78,300 $78,550 Stormwater 2019 $78,500 $82,500 Campus Stormwater 2019 $78,775 $79,349 Hempstead Renovation Nakamura Physics Documentation ubility state Renovation Hempstead Hempstead Materials: Materials 2019 2019 $153,200 $155,600 $195,600 $199,800 Average Cost: $232,785 Capital Projects Cost by Green Feature Cost by Campus Project Budgets Project Ty*** +