How do I offset a row of cells a defined number of columes?
 

I have cashflow forecasts for each month for the duration (varying from say 3
to 12 months) of a number of projects. I want to offset these rows of values
by a number of months to align with a start date before adding each month to
get a combined cashflow for all projects.

How do I offset a row of cells a defined number of columes?
 

Does this help

=SUM(OFFSET(A1,,num_months,num_rows_to_sum,1))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"steve from devon england" <steve from devon
wrote in message
...
I have cashflow forecasts for each month for the duration (varying from
say 3
to 12 months) of a number of projects. I want to offset these rows of
values
by a number of months to align with a start date before adding each month
to
get a combined cashflow for all projects.