In cell N$16,$ create a formula using the DCOUNTA function to count the number of projects for client KERRA, using the data in the entire Sales table $($Sales$[$#AII$])$ and counting the values in the Client ID column $("$Client ID$")$ that are equal to the values in the range M$14$:M$15.$

Nadia also needs to calculate the total sales for marketing plans and the average sales for clients in New Jersey. In cell N$2$O$,$ create a formula using the DSUM function to calculate the total sales for marketing plans, using the data in the entire Sales table $($Sales$[$#AII$])$ and totaling the values in the Total Sales column $("$Total Sales"$)$ for services equal to the values in the