» Summing Values Using Indirect Cell References
CATEGORY - Excel Summing
VERSION - All Microsoft Excel Versions
Problem: 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:
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- Microsoft Windows XP Inside Out
- The Interpretation of Financial Statements
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- The Basics of Finance: Financial Tools for Non Financial Managers
No comments have been submitted.
