Create formulas for the exercises below:

$1.-$ Create a formula in cell D$21$ to count the number of records from range C$4$:L$15$ where Market is equal to cell C$21$

$2.-$ Create a formula in cell E$27$ to sum the monthly balance from range C$4$:L$15$ where Market is equal to cell C$27$ and month equal to cell D$27$

$3.-$ Create a formula in cell E$33$ to count the number of records from range C$4$:L$15$ where Market is equal to cell C$33$ and Account equal to cell D$33$

$4.-$ Create a formula in cell E$39$ to sum the total balance from range C$4$:L$15$ where Market is equal to cell C$39$ and Account equal to cell D$39$

$5.-$ Create a formula in cell E$45$ to sum the total balance from range C$4$:L$15$ where Market is equal to cell C$45$ and Account Name contains the text in cell D$45$

Market Account Name Balance

MAR$-03$ Wages Create formulas for the exercises below:

$1.-$ Create a formula in cell $D21$ to count the number of records from range $C4$:$L15$ where Market is equal to cell $C21$

$2.-$ Create a formula in cell $E27$ to sum the monthly balance from range C$4$:L$15$ where Market $i$

C$27$ and month equal to cell D$27$

$3.-$ Create a formula in cell E$33$ to count the number of records from range C$4$:L$15$ where Market is equal to cell C$33$ and Account equal to cell D$33$

$4.-$ Create a formula in cell E$39$ to sum the total balance from range C$4$:L$15$ where Market is equal to cell C$39$ and Account equal to cell D$39$

$5.-$ Create a formula in cell E$45$ to sum the total balance from range C$4$:L$15$ where Market is equal to cell C$45$ and Account Name contains the text in cell D$45$

$[$ Market $,$ Account Name $,$ Balance $],[$ MAR$-03,$ Wages $,]$