Hi All,
I am trying to forecast scores of various insitutions in 2017, 2018, 2019 and 2020 based on their existing scores between 2007 and 2016 (not all the institutions have scores in all these years).
My aim is to do this with as little manipulation as possible so I tried array formulas.
My formula does not work, the yellow field is giving a different results from the grey validation field.
The formula behind the yellow field which needs to be fixed: ={FORECAST(E7330, IF($C$2:$C$7329=2618, $G$2:$G$7329), IF($C$2:$C$7329=2618, $E$2:$E$7329))}
The formula of the grey validation field: =FORECAST(E7330, G7327:G7329, E7327:E7329)
I also tested the array with a SUM in the blue field and that works fine: {=SUM(IF($C$2:$C$7329=2618, $E$2:$E$7329))}
How would you fix the formula with the arrays (yellow field)?
Thanks for your suggestions!
My data looks like this:
Forecast.jpg
Bookmarks