Well, it took some doing & I probably didn't accomplish it in the most conventional manner, but it's done & it seems to work...OOF!!
Ended-up creating this formula using COUNTIF to figure out what month it is at any given time, and LOOKUP to go find the corresponding percentage values:
=IF(12-COUNTIF($D$9:$D$20,"-")=0,0,LOOKUP(12-COUNTIF($D$9:$D$20,"-"),V9:V20,W9:W20))
Then I used various forms of this formula in the array to calculate the running percentages as each month progressed between 2 sequential years:
=IF('2011'!F18=0,SUM(F$11:F18)/100,(SUM(F$11:F18)/SUM('2011'!F$11:'2011'!F18))-1)
Since I'm a bit of a self-taught hacker, I would love any feedback on ways I could of done it different/simpler. Although, I'm not sure if I'm going back to make major changes. ;o)
Bookmarks