Hi
I am looking for some assistance pls. I am trying to get the cumulative total for 12 months every time i select the date in Sheet 1 cell D1 i.e. e.g. if i select 2019-02 it should pick all the data with 2018 03 to 2019 02 tags therefore always picking 12 months running total. I have tried to use a sumif but its not dynamic as i have to change the criteria manually in the formulae. your assistance will be much appreciated workbook attached
I am looking for some assistance pls. I am trying to get the cumulative total for 12 months every time i select the date in Sheet 1 cell D1 i.e. e.g. if i select 2019-02 it should pick all the data with 2018 03 to 2019 02 tags therefore always picking 12 months running total. I have tried to use a sumif but its not dynamic as i have to change the criteria manually in the formulae. your assistance will be much appreciated workbook attached