1. 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.
2. 
   
3. 

Transcribed Image Text:

D E G M N 1964= Hempstead University Foundation 1 2 ID - Project Name - Project Type Campus Green Feature - Completed Budget - Final Cost Project Type Average Cost $148,737 $63,783 Number Total Cost 3 EX-4096 Didrikson Gymnasium 4 LA-5066 Wales Lake 5 RE-1751 $213,475 $225,631 $743,687 $510,261 Expansion La Croix 2016 Expansion 5 Landscape Materials $59,320 $60,600 Hempstead Hempstead 2016 Landscape 8 $89,754 $60,935 Ardmore House Renovation Materials 2017 $82,500 New Construction $4,292,507 $613,215 $118,311 $123,012 6 EX-4188 Transit Center Hempstead $62,750 $1,183,113 Expansion New construction Newburgh Stormwater 2017 Renovation 10 $369,037 7 NE-3027 Bixbury Apartments LA-5104 Hempsted Field 9 RE-1854 $689,430 $42,500 Green roof 2017 $700,225 Upgrade $42,850 $56,127 $200,326 Landscape Hempstead Newburgh 8 Stormwater 2017 Sullivan Library Renovation Green roof 2018 $55,750 Final Cost 10 RE-1890 Richardson Hall Renovation $195,640 Newburgh Newburgh Stormwater 2018 >100000 11 LA-5218 Freestone Plaza Landscape Stormwater 2018 $48,700 $48,850 Number of Projects: 16 12 EX-4209 Boyle Residences 13 NE-3153 Ambani International Center New construction Hempstead 14 RE-1904 Clarkson Laboratory Expansion Newburgh Materials 2018 $109,800 $110,456 Green roof 2019 $847,400 $889,325 Completed Renovation La Croix Stormwater 2019 $78,775 $79,349 2019 15 LA-5276 Alumni Center Landscape Hempstead Materials 2019 $78,300 $78,550 Number of Projects: 16 RE-1922 Founders House Solar panels $32,500 $32,500 Hempstead Hempstead Renovation 2019 17 RE-1957 18 RE-1961 Grounds and Ruilding $195,600 $199,800 $82 500 Nakamura Physics Renovation Materials 2019 Campus Renovation Newburah Stormwater 2019 Š78 500 Nowburah D E G M N 1964= Hempstead University Foundation 1 2 ID - Project Name - Project Type Campus Green Feature - Completed Budget - Final Cost Project Type Average Cost $148,737 $63,783 Number Total Cost 3 EX-4096 Didrikson Gymnasium 4 LA-5066 Wales Lake 5 RE-1751 $213,475 $225,631 $743,687 $510,261 Expansion La Croix 2016 Expansion 5 Landscape Materials $59,320 $60,600 Hempstead Hempstead 2016 Landscape 8 $89,754 $60,935 Ardmore House Renovation Materials 2017 $82,500 New Construction $4,292,507 $613,215 $118,311 $123,012 6 EX-4188 Transit Center Hempstead $62,750 $1,183,113 Expansion New construction Newburgh Stormwater 2017 Renovation 10 $369,037 7 NE-3027 Bixbury Apartments LA-5104 Hempsted Field 9 RE-1854 $689,430 $42,500 Green roof 2017 $700,225 Upgrade $42,850 $56,127 $200,326 Landscape Hempstead Newburgh 8 Stormwater 2017 Sullivan Library Renovation Green roof 2018 $55,750 Final Cost 10 RE-1890 Richardson Hall Renovation $195,640 Newburgh Newburgh Stormwater 2018 >100000 11 LA-5218 Freestone Plaza Landscape Stormwater 2018 $48,700 $48,850 Number of Projects: 16 12 EX-4209 Boyle Residences 13 NE-3153 Ambani International Center New construction Hempstead 14 RE-1904 Clarkson Laboratory Expansion Newburgh Materials 2018 $109,800 $110,456 Green roof 2019 $847,400 $889,325 Completed Renovation La Croix Stormwater 2019 $78,775 $79,349 2019 15 LA-5276 Alumni Center Landscape Hempstead Materials 2019 $78,300 $78,550 Number of Projects: 16 RE-1922 Founders House Solar panels $32,500 $32,500 Hempstead Hempstead Renovation 2019 17 RE-1957 18 RE-1961 Grounds and Ruilding $195,600 $199,800 $82 500 Nakamura Physics Renovation Materials 2019 Campus Renovation Newburah Stormwater 2019 Š78 500 Nowburah

Answer rating: 100% (QA)

Solution COUNTIF function counts the cells which are equal to a value in a given ... View the full answer