Tip Printed from ExcelTip.com

---

Summing Values In a Range Specified By Indirect Cell References


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))