Summing several rows using index function

[howard]

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!1506:1506,95)+SUM(INDEX(sheet1!1507:1507,95))))

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

Your assistance will be most appreciated

 

[scottylad2]

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!1506:1506,95)+SUM(INDEX(sheet1!1507:1507,95))))

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

Your assistance will be most appreciated

You could incorporate the offsett function into your Index. But i'm not seeing any column refs in

You could make a dynamic named range that expanded as colums were added using offset

 

[howard]

Thanks for the reply. The column Ref is 95. How would I incorporate the offset function with the index function?