» 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:
- Marketing Plans
- Special Edition Using Microsoft Outlook 2002
- The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
- Millionaire Real Estate Mentor : The Secrets of Financial Freedom through Real Estate Investing
- MP Managerial Accounting w/ Topic Tackler, Net Tutor, & PowerWeb
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
Wrong comment posting
Dennis Taylor
My previous posted comments should have gone to this topic:
Ranking numbers in a dynamic list
error in indirect formula
Bill Cohen
» Summing Values In a Range Specified By Indirect Cell References
CATEGORY: Summing VERSIONS: All Microsoft Excel Versions
Problem:
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)) ... should be
=SUM(INDIRECT(B2&":"&C2))
=IF(ISBLANK(A4),"",RANK(A4,A:A))