» Summing Values In a Range Specified By Indirect Cell References
CATEGORY - Summing
VERSION - 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))
Book Store:
Recommended Books:
- Accounting for Dummies
- The Financial Numbers Game: Detecting Creative Accounting Practices
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
- The Total Money Makeover. : A Proven Plan for Financial Fitness
- Harry Potter and the Order of the Phoenix (Book 5)
No comments have been submitted.
