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.