3. In the range 32:M7, Camille wants to summarize project information. Start by calculating the number of each project type as follows: a. b. 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 33. Fill the range K4:K7 with the formula in cell K3. M3 Hempstead Unnersity Foundation AVERAGEIF($C$3:$C$35,$13,5H$3:$H$35) 10 1500 Wale Project Name Project Type Landinge Campu Green Feature Complated Budget Final Cest Project Type Number Total Cost Average Cost Hempstead 3018 $50,320 560400 Expanie 574348 STAR, 737 4CX-4103 Santiage field Expansion Newburgh Solar panels 201 $124,300 5136,507 Landwage $530,301 541,783 Ex-40% Didon Gymnasium 159 Materials 7016 STA 5225,831 w Contructie 7 54292507 $433,215 6A5104 Hempted Field Landrape Stormwater 2017 542,500 $41,50 30 SLIRLIES 7 YALE Tops Canter Exp 2017 542,750 540,3 Megrade 5369017 5122017 A5113 inch Ma Landscape Hempstead Material 2017 $74,500 $78024 915 Andmark Have Fenevstran 3017 382300 585754 Final Cal 10-3045 Charles Street Entrance New construcion Hempded Materials 3017 541,750 543,750 10000 11-3027 xbury Apa Green yout 3037 SARLANS 5700225 12 UP 2011 Manchel Observatory Opgrade Hempstead Solar panels 2019 $14,000 $34,600 13 Ass Mas Center 14 A 5218 este Park Landroge TA Cre Newburgh 2018 SATAVO LIMO Completed Stormwater 3018 $48,700 548 850 2019 1514 Sutivan ray 2018 355758 Number of french 16 420 Boyle Residences Newburgh Me 2018 $10000 $110,436 1750 hand a hewww water 2018 SIP600 S 18-1922 founders o Solar panels 7019 $13,500 wburgh 191977 Thats famly 1509 2019 $12,500 351500 SURISSO9 20 A 1376 Ames Center Landicape Humpstrat Materials 3059 578.300 $78.550 211-1911 hd bildeg 22 1 1904 Orkaan Laboratory heben La Crote 2019 1738 S1306 301 $78.775 Hampsteet 201 $435,300 S8500 Average Cont SEEE,FRE 2019 $195,000 $1900 1710.758 2019 3847 ADO Landicapt 281-1953 von Gradate eng 30 SETS Cuarter 2530 $125,000 SIRSAMS SIELAIS Materials 2030 snakes MCA SASA AG Maunal SAX490 584.87 SITORY 311AM 2011 $1PE400 LIPANT