Forum Discussion
Multi-line range used for summing specific column
I have a file in which I'm going to be constantly expanding the vertical length of a 36 month span of months. Specifically, I'll have various sections (all very similar, but not identical, in struct...
A11 should read 14 (because right now the named range only includes the 5th and 7th row. Once I update the range to also include the 9th row, I'll want the row 11 result to automatically show 27 (the addition of 13 from A9)
hope that clarifies.
In the attached file, the formula in A11 is:
=SUM(INDEX(A:A,G1):INDEX(A:A,G2))
G1 and G2 are the cell references for the start and end of the row to sum, respectively.