Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts
    I have several rows that I want to add using the index function for eg row 1504:1510-see my formula below

    =-SUM(INDEX(sheet1!1504:1504,95)+SUM(INDEX(sheet1!15 06:1506,95)+SUM(INDEX(sheet1!1507:1507,95))))

    The formula must refer to cells CQ1504:CQ1510 (sheet1) The formula is placed in cell C3 on sheet Stats

    Is there and easier way to add these rows using the index formula. The reason why I am using the index formula instead of the offset formula is that 1 new column is added each month

    Your assistance will be most appreciated

  2. #2
    New Lounger
    Join Date
    Dec 2009
    Location
    Woodbury, GA
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts
    =SUM(INDEX(A1504:CQ1510,0,95)) should do it nicely.

  3. #3
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts
    Hi Mark

    Thanks for the help, much appreciated

Posting Permissions

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