on the enclosed file, you'll find two sheets, one called "Forecast", and the other's "Actual".
I need a formula where, if the number on the right cornet of the "Forecast" sheet is one, the
"Actual Forecast" has to be the sum of all monthly forecast on the same sheets. IF the number is 2, meaning February, then the "Actual Forecast" has to be the sum of the sheet "Actual", month January, plus the forecast of the remaining months on the "Forecast" sheet. When the number will be 3, then "Actual Forecast" = sum of month January + February presents on the "Actual" sheet, plus the remaining months on the "Forecast sheet"..and so on.
If you didn't understand something, feel free to ask me more specifications.
Thank you in advance for your support and regards,