In the Invoice Reports worksheet, complete the Sales Rep Analysis report. In the commission and total amount columns (columns C and D), use the SUMIF function to summarize sales commissions (column E in Aging table in the invoices worksheet) and the invoice amount (column F in the aging table) for each sales rep. Please give me instructions on how to accomplish this matter.

6 Cut General Copy Format Painter Conditional Format as Formatting- Table, St. Paste e & Center" Clipboard Font Alignment Number Styles B7 A. Accounts Receivable Aging Number of Sales Rep Analysis Total invoices Amount Commission Total Amount 0 0 0 0 0 Invoices 2 Reps 3 Boehmer 4 Johnson 5 Lesure 6 Riley 7 Total Current 1-30 days 31-60 days 61-90 days Over 90 days Totals 10