a$.$ In cell J$2,$ enter a formula using the COUNTIF function that counts the number of proposed Commercial projects, using ProposedProjects$[$Project Type$]$ as the range and cell I$2$ as the criteria.

b$.$ Fill the range J$3$:J$5$ with the formula in cell J$2.$

c$.$ In cell K$2,$ enter a formula using the SUMIF function that totals the funding for proposed Commercial projects, using ProposedProjects$[$Project Type$]$ as the range, cell I$2$ as the criteria, and ProposedProjects$[$Funding$]$ as the sum$\_$range.

d$.$ Fill the range K$3$:K$5$ with the formula in cell K$2.$

e$.$ In cell L$2,$ enter a formula using the AVERAGEIF function that averages the funding for proposed Commercial projects, using ProposedProjects$[$Project Type$]$ as the range, cell I$2$ as the criteria, and ProposedProjects$[$Funding$]$ as the average$\_$range.

f$.$ Fill the range L$3$:L$5$ with the formula in cell L$2.$