Adjust formula range based on other cell values

[Sardius]

Given a simple formula in cell D3: =SUM($C5:$C20)

Can the formula be written so that the row numbers (5 and 20 in this case) change based on other cell values?
Let's say the desired start row and end row are stored in A3 and B3

If A3 = 10 and B3 = 15, then the formula would behave as if it were written "=SUM($C10:$C15")

[Fotis1991]

Hi

One way(using a helper column) is this.

In E3>>="C"&A3

iN e4>>="C"&B3

Then use this formula:

=SUM(INDIRECT(E3):INDIRECT(E4))

Hope to helps you.

[mahju]

May be another solution

Please Login or Register  to view this content.

Regard

[Alf]

Expanding fotis1991 solution a bit you could do it in one sweep without a helper column.

Please Login or Register  to view this content.

Alf

[Sardius]

I "discovered" a similar solution without needing the helper column. See linked file

RangeFormula.xls

This uses an alternate method to use numbers instead of a label to reference columns.

To convert number to column header (B5 contains a number, not a column label):

Please Login or Register  to view this content.

And combining the two, it gets a bit lengthy but it is possible:

Please Login or Register  to view this content.