Discussion:
Q1. In the Sales by Div sheet, only the Qtr subtotals should be displayed, Do not show the details.
Q2. In Totals & Averages sheet, please add average shown as belowPlease refer to word for questions and make correction to excel sheet.
Q3. In column C of the Div Awards sheet, please indicate K4 (referring to 5%) as an absolute reference.
Attachment:- Average sales data.rar