The Summary sheet is designed to display two key averages from the PivotTable on the Summary sheet. Display the Summary sheet. In cell B2, insert the GETPIVOTDATA function that references cell C4 on the PivotTable in the Sold Out sheet. In cell B3, insert the GETPIVOTDATA function that references cell C9 on the PivotTable in the Sold Out sheet