» Summing data from a cell in a number of sheets in Microsoft Excel
CATEGORY - Summing
VERSION - All Microsoft Excel Versions
Sum a single cell from a number of sheets.
For example: A workbook has four successive sheets. The names of the sheets are January, February, March and April.
The formula: =SUM(January:April!B2).
- Select the sheet in which you want to enter the formula.
- Type =SUM(.
- Select the tab for the first sheet, January.
- Press Shift, and select the tab for the last sheet, April.
- Select Cell B2.
- Press Enter.
Book Store:
Recommended Books:
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- Financial Modeling - 2nd Edition
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
No comments have been submitted.
