I probably should have posted this in the formulas and functions section. How do I move it?
I'm using an index(match) function to find a particular cell and that works. What I'd like to do is add that to the 11 cells to its right in order to get the yearly values.
The only way I can think of doing it now is copying and pasting the formula for each value, manually changing the index array over 1 each time and adding them all together
For example:
=IFERROR(INDEX('CF'!$D$360:$D$708,MATCH(Summary!O3,'CF'!$C$359:$C$708,0)+12,1),0) + =IFERROR(INDEX('CF'!$E$360:$E$708,MATCH(Summary!O3,'CF'!$C$359:$C$708,0)+12,1),0)
Then doing this 10 more times.
There's got to be a better way. Is there a basic formula to do it?
Bookmarks