# Calculate range based on cell values

1. ## Calculate range based on cell values

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.  Register To Reply

2. ## Re: Calculate range based on cell values

Jon,

You need to use INDIRECT... ``Please Login or Register  to view this content.``  Register To Reply

3. ## Re: Calculate range based on cell values

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

=SUM(INDEX(A:A,C5):INDEX(A:A,D5))  Register To Reply

4. ## Re: Calculate range based on cell values

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.  Register To Reply