a. In cell J2, enter a formula using the COUNTIF function that counts the number of proposed Commercial projects, using Proposed Projects[Project Type] as the range and cell I2 as the criteria.