Each cell in an Excel spreadsheet has a unique address, called a cell reference. This reference combines the letter that represents the cell's column with the number that represents its row. Cells in ...

Microsoft Excel 2010 provides a formula for calculating the average value from multiple worksheets in a workbook. Before you apply this formula, check that each worksheet is formatted the same way.