Adding a range of cells based on addressing from a match

Important Notice


Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

    I have table1 that has the header row of year and the A column as the project name, and in each cell is a factor.


    I am using the formula =INDEX(D14:130, MATCH(M17, C14:C30,0), MATCH(P13, D13:I13,0)) this gets me the value of the factor and works great.


    What I need to do is sum the factors from this cell going back x number of cells, where x is determined by a different cell (say A2). The catch is that there sometime wont be enough cells to go back that far, because my Table1 only starts from 2005, but A2 might be 25, so it would try to go back 25 years.


    Thanks,

    Re: Adding a range of cells based on addressing from a match


    It's hard to imagine what you want without a sample of the data and an explanation based on that data.


    When you click reply there will be a new button labeled go advanced, click on that button then there will be a paperclip icon in the toolbar, click on that icon and follow the instructions.

    Bruce :cool:

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login