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

[Guest]

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]

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
(e-mail address removed)> wrote in message
news:[email protected]...