I have a cell (say H6) containing concatenated information to result in a range (for example, "A1:C11"). If I wanted to sum up this range and typed it manually as =sum(A1:C11) it works, but if I wanted to refer to the same information but in a concatenated form that's in cell H6, I cannot. The formula I use is =sum(indirect("H6")).
I tried copying cell H6 and pasting the value into cell I6, and copying that value from the formula bar back into the summation cell, it works.
How can I reference the contents of cell H6 so that when it's plugged into the sum formula it'll work?
Bookmarks