+ Reply to Thread
Results 1 to 4 of 4

Calculate range based on cell values

  1. #1
    Registered User
    Join Date
    04-08-2009
    Location
    Glasgow, Scotland
    MS-Off Ver
    Excel 2004 for Mac
    Posts
    2

    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.

  2. #2
    Forum Contributor
    Join Date
    04-01-2009
    Location
    Irvine, CA
    MS-Off Ver
    Excel 2010
    Posts
    280

    Re: Calculate range based on cell values

    Jon,

    You need to use INDIRECT...

    Please Login or Register  to view this content.

  3. #3
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Suffolk, UK
    MS-Off Ver
    2002, 2007 & 2010
    Posts
    21,528

    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))

  4. #4
    Registered User
    Join Date
    04-08-2009
    Location
    Glasgow, Scotland
    MS-Off Ver
    Excel 2004 for Mac
    Posts
    2

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1