W
Warrain
I have 12 columns of numbers (one for each month) representing actuals for
past months and forecasts for future months and a total for the year. This is
updated each month when actual numbers for the month replace forecast for
that month. Each month I need to update the sum of the actual columns year to
date. Is there a conditional formula, or some other method, that would
achieve this without having to update the formulae each month for each line?
Many thanks.
past months and forecasts for future months and a total for the year. This is
updated each month when actual numbers for the month replace forecast for
that month. Each month I need to update the sum of the actual columns year to
date. Is there a conditional formula, or some other method, that would
achieve this without having to update the formulae each month for each line?
Many thanks.