In the range $J2$:$M7,$ Camille wants to summarize project information. Start by calculating the number of each project type as follows:

a$.$ In cell K$3,$ 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.$

b$.$ Fill the range $K4$:$K7$ with the formula in cell $K3.$

In column L$,$ Camille wants to calculate the total cost of each project type. Determine the total costs as follows:

a$.$ In cell L$3,$ enter a formula using the SUMIF function that totals the cost for Expansion projects, checking that the column of project types in the Projects table $($Projects$[$Project Type$])$ is equal to the value in cell J$3,$ and that the formula totals all the final costs $($Projects$[$Final Cost$]).$

b$.$ Fill the range $L4$:$L7$ with the formula in cell $L3.$

ew Perspectives Excel $365/2021$

Module $11$:SAMProject la