» Summing Values In a Range Specified By Indirect Cell References
CATEGORY - Summing
VERSION - All Microsoft Excel Versions
Column A contains a list of numbers.
Columns B:C contain pairs of cell references, representing the beginning and end of a specific range from column A, which we would like to sum.
How could we create a formula that will sum the values included in each of the ranges specified in columns B:C?
Solution:
Using the INDIRECT function, as follows:
=SUM(INDIRECT(B2&"":""&C2))

Book Store:
Recommended Books:
- Positioning: The Battle for Your Mind
- Accounting Principles, with CD, 6th Edition
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- Microsoft Access 2002 for Dummies
- Investments + S&P Card + Powerweb + StockTrak discount coupon
No comments have been submitted.


