One of Excel’s greatest tricks is the dimensional or 3D reference. This feature, which allows you to create formulas that refer to the same cell or range on multiple worksheets, simplifies the ...

This same range of cells on multiple worksheets is a 3-D reference. Open the Excel workbook. Click the worksheet cell where you wish to enter the average value.