In column $D,$ calculate the sales rep's commissions by multiplying the commission rate $*$ the invoice amount.

Add totals at the bottom of the Commissions and invoice amounts columns.

In the Invoice Analysis worksheet:

$9.$ Format columns appropriately.

$10.$ In the B column use a COUNTIF function to count the number of invoices for each sales rep. Your functions must contain table references.

$11.$ In the Commission column, use a SUMIF to total the commissions for each salesrep.

$12.$ In the Total Amount column, use a SUMIF to total the invoices for each salesrep.

$13.$ Create totals at the bottom of each column and format appropriately. $($Hint: totals should equal the totals you created in the Invoices worksheet$)$

$14.$ In the $Nbr$ Invoices column use COUNTIFS to count the invoices in eachaging category.

$15.$ In the Amount column use SUMIFS to total the invoices in each aging category.

$16.$ Create totals at the bottom of each column and format appropriately. $($Hint: totals should equal the totals you created in the Invoices worksheet and in the Sales Rep Analysis on the Invoice Analysis worksheet.

$17.$ Add your $3-$line title to the Invoice Analysis Worksheet.