(Row 8 is used here just as an example)



I'd like to have a formula in cell D8 that sums the values in cells x8-y8, where x and y (the columns) can be defined by typing the column values in one or more other cells. For example, I'd type "F" in cell D1, and "M" in cell D2, and cell D8 would responsively display the sum of cells F8-M8.

Is this possible?

For example:

=SUM(INDIRECT($D$1&8&":"&$D$2&8))

Thank you. Is there a way to have the row number automatically update when the formula is pasted in other rows, like would happen with a straightforward formula?

=sum(indirect($d$1&row(8:8)&":"&$d$2&row(8:8)))

That worked perfectly - thank you!