Sum Formula

[Rob Fenn]

I have two spreadsheets in a workbook. One has forecasts by week and the
other is used for planning purposes.

I need to put sum formula in my planning sheet to add up the forecasts for a
set period of time.

The number of weeks to sum would vary by line (I have over 500 lines in my
spreadsheet so don't want to have to do this manually.

e.g

If I need to sum 6 weeks the formula would be SUM(E6:J6)
If I need to sum 8 weeks the formula would be SUM(E6:L6)
If I need to sum 9 weeks the formula would be SUM(E6:M6)

TIA

Rob

 

[Debra Dalgleish]

With the number of weeks in cell B4 --

=SUM(OFFSET(Forecasts!E6,0,0,1,Sheet1!B4))

Rob Fenn