Hello I have a table similar to below that displays actual and forecasted numbers. I need to sum the most recent 12 months of actual's. I believe I will be using the offset function but cant figure out how to get it to start with the furthest right actual column?
=Sum(OFFSET($A$4,0,(how do i get furthest right cell with "Actual"??)-12,1,12))
my file has the previous 12 months of data, the table above wouldn't let me make it large enough. In this case I would need to sum 2019.Mar and before.
Thank you for any help,
Greg
=Sum(OFFSET($A$4,0,(how do i get furthest right cell with "Actual"??)-12,1,12))
2019.Jan | 2019.Feb | 2019.Mar | 2019.Apr | 2019.May | 2019.Jun |
Actual | Actual | Actual | AprFcst | AprFcst | AprFcst |
100 | 200 | 200 | 150 | 150 | 150 |
my file has the previous 12 months of data, the table above wouldn't let me make it large enough. In this case I would need to sum 2019.Mar and before.
Thank you for any help,
Greg