Create a PivotTable to summarize sales for each sales person.

Insert the PivotTable on the SalesPerson worksheet.

Place SalesPerson as the row labels.

Use an appropriate presentation of the Dollars field as the PivotTable values to display the total, average, and number of sales.