I'm trying to create a KPI sheet where one of the cells need to sum cells in another sheet, depending on which month it is, to create a YTD-value. So for each month this needs to sum another column to the right.
Right now I use a SUM(Sheet2!BE4:BI4) formula which I have to manually drag 1 column to the right each month, so next month it will be SUM(Sheet2!BE4:BJ4)
I've done a cell which retrieves which cell it should use with the following formula which in this case returns the text BI: =CONCATENATE(CHAR(66);CHAR(68+MID(TEXT($D$18;"DD/MM/YYYY");5;1)))
What I need is, when I change month in the cell "D18" (which is referenced through the CONCATENATE formula), the "BI4" will change. If I increase the month, it will automatically change to "BJ4" and if I decrease the month, it will change to "BH4". Is that possible?