» Extending the Range of the SUM Formula
CATEGORY - Summing
VERSION - All Microsoft Excel Versions
To extend the range of the SUM formula:1. In cell C7 insert the SUM formula with the total for range A1:A5.
2. Select cell C7.
3. Press F2 to enter edit mode.
OR
Click any place within the formula in the Formula Bar.
4. Drag the handle of the range to extend the range (the handle is located in the bottom-right corner of the range).
5. Press Enter.
Book Store:
Recommended Books:
- The Intelligent Investor: The Classic Bestseller on Value Investing
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- The Guide to Understanding Financial Statements
- The 22 Immutable Laws of Branding
- Microsoft Word Version 2002 Step By Step (With CD-ROM)
No comments have been submitted.
