» Consolidate with formulas if the row & column headers of all worksheets are identical in Microsoft Excel
CATEGORY - Excel Consolidating
VERSION - All Microsoft Excel Versions
Example:
In the workbook 3 sheets - January, February and March contain tables with salary data.
On every sheet, the items in cells A2:A8 are identical.
On every sheet, the employees listed in B1:H1 are identical and never change.
Add a new worksheet, change the worksheet name to Total. Use a formula like the one shown in cell B2 ( see screen shot ) to add the other sheets.
The formula in Cell B2 is =SUM (January:March!B2).
The technique for entering a formula to sum a single cell on a number of sheets.
- Select Cell B2 in the sheet name Total.
- In the cell, type =SUM, and press Ctrl+A (the shortcut for displaying the formula argument box).
- In the first argument box, select the name of the first sheet in the range January.
- Press Shift, and select the last sheet in the range March.
-
Click OK.
Screenshot // Consolidate with formulas if the row & column headers of all worksheets are identical in Microsoft Excel 
Book Store:
Recommended Books:
- Real Estate Loopholes: Secrets of Successful Real Estate Investing
- Harry Potter and the Order of the Phoenix (Book 5)
- Marketing Plans That Work, Targeting Growth and Profitability
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- Accounting and Financial Fundamentals for Nonfinancial Executives
- MP Managerial Accounting w/ Topic Tackler, Net Tutor, & PowerWeb
No comments have been submitted.
