Calculate range based on cell values

[jongleurjon]

I’m a complete Excel novice, but I’m sure that Excel can do this: I just don’t know the markup.

I have a gazillion numbers in column A. Cell C5 is a number and D5 is a number. Cell E5 needs to give me the sum of cells in column A from the value of C5 to D5. I.e., something like:

Please Login or Register  to view this content.

So that, if C5 is 100 and D5 is 200, the result in E5 will be the sum of the range A100 to A200. If C5 or D5 changes, the calculated range will change too.

How does one express this in Excel language? I can’t find it anywhere in the help manuals.

Thanks,
Jon.

[Chance2]

Jon,

You need to use INDIRECT...

Please Login or Register  to view this content.

[DonkeyOte]

INDEX is another alternative, moreover it's non-volatile unlike INDIRECT:

=SUM(INDEX(A:A,C5):INDEX(A:A,D5))

[jongleurjon]

Thank you. This is exactly what I needed.

I’ve gone with Indirect as I could easily understood how it worked, but thank you both very much.

Jon.