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

steve from devon england · Feb 16, 2006

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.

Bob Phillips · Feb 16, 2006

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
[email protected]> wrote in message
news:[email protected]...