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:
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.
Bookmarks