conditional formula

[Guest]

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.

 

[Richard Buttrey]

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.

Try using SumIf

You'll need to identify which columns are Actuals and which Forecast
if your model is not already doing this. So assuming your month
columns are B:M with the month name in row 2, and data starting in row
3, identify in row 1 whether the column is an Actual or Forecast with
an "A" of "F" respectively.

Then in A3 put

=SUMIF($B$1:$M$1,"A",B3:M3)

and copy down column A.

HTH

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

 

[Guest]

Thank you so much Richard. It worked a treat. Will save me oodles of time.
Cheers from Brizzie
Warren