Thanks Matt, thats great.

I still seem to have one slight problem though, as my "actual" figures
are pulled from another spreadsheet it seems to be putting future
months in as 0.00 rather than leaving the cell null. This obviously
knocks out my average, is there anyway around this problem?

Thanks again


--
DangerMouse
------------------------------------------------------------------------
DangerMouse's Profile: http://www.excelforum.com/member.php...o&userid=27755
View this thread: http://www.excelforum.com/showthread...hreadid=553165