» Summing Values Using Indirect Cell References
CATEGORY - Excel Summing
VERSION - All Microsoft Excel Versions
Numbers Range (A2:C6) contains numbers.
Columns E & F contain pairs of cell references that indicate the beginning and end of parts of Numbers Range that we wish to sum.
We want to create formulas to calculate the sum for each specified sub-range.
Solution:
Use the SUM and INDIRECT functions as shown in the following formula:
=SUM(INDIRECT(E2&":"&F2))
Book Store:
Recommended Books:
- Accounting for Dummies
- Microsoft Excel 2002 Visual Basic for Applications Step by Step
- Microsoft Office XP Introductory Concepts and Techniques
- The Intelligent Investor: The Classic Bestseller on Value Investing
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
- Windows XP All-in-One Desk Reference For Dummies
No comments have been submitted.
