formula to equate total forecast cost and total budget cost

Hi

I attached a workbook. Basically, i need to readjust the formula for forecast cost from March 2010 to Dec 2010 (Range D3:M5) so that the total cost (Range N3:N5) will be the same as total budget cost (Range N11:N13).

The different between total forecast cost and total budget cost is because some cost in Jan & Feb 2010 were not taken up in Actual. Now, i need to add those not taken up amount in Jan & Feb 2010 to March - Dec 2010 by smooth it out so that total cost will be equal to total budget cost.

I hope you understand what i am trying to say.

Thanks

I hope you understand what i am trying to say.

Not without the attachment??

Do you perhaps mean for something along the lines of:

D3: =($N11-SUM($B3:$C3))/COUNTIF($D$1:$M$1,"Forecast")
copied across matrix D3:M5