» Using a Range Name in a Formula
CATEGORY - Excel Range Name
VERSION - All Microsoft Excel Versions
1. Define the following range Names for ranges B2:B11, C2:C11 and D2:D11, respectively (to define range Name see Tip #188): January_2004, February_2004, and March_2004 (see the screenshot below).
2. Select a cell and type the formula =SUM.
3. Press Ctrl+A.
4. Select the first argument box and press F3.
5. Select the Name January_2004, and then click OK.
6. Paste the Names February_2004 and March_2004 in the next two argument boxes, and then click OK.
The following formula has now been inserted into the cell:
=SUM(January_2004, February_2004, March_2004)
Book Store:
Recommended Books:
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- Financial Peace: Revisited
- The Financial Numbers Game: Detecting Creative Accounting Practices
- Microsoft Outlook Version 2002 Step by Step (With CD-ROM)
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
- Essentials of Accounting and Post Test Booklet 8, Eighth Edition
No comments have been submitted.
