» 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:
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- Microsoft Excel VBA Programming for the Absolute Beginner
- Investing in Real Estate, Fourth Edition
- Financial Peace: Revisited
- Business Plans For Dummies®
No comments have been submitted.
