In enclosed xlsx-file I have monthly results for 24 months. I would like to have a formula in a column calculating the "Last 9 months accumulated result" depending on choosen report month (choosen in a separate cell). Have done similar with INDEX + OFFSET I Think, but don´t get this working. In enclosed file you will see the data and desired solution.QuestionExcelforum.xlsx
Bookmarks