I have a financial forecasting spreadsheet with the following values:
1. Forecast for the month
2. Actuals for the month
3. Variance
At the end of a one year period, I have total forecasted for the year, actuals spent for the year, variance and forecast to complete. This is the value I need help with.
The forecast to complete field needs to calculate the following:
We are in the month of August (month 8) and up until July we have actuals values populated within each month. Is there a formula which can add the forecast fields from August through to December considering the fact that actuals have been populated for all previous months?
Thanks.
Bookmarks