variable cell reference

[Jim B]

For example, I am summing cells A1 to A3. Then I'd like
to increment that by an amount I specify in cell B1. I'd
like this to work, but it doesn't:
=sum(A(1+b1):A(3+B1))

That is, I can't make my cell-call within a function to be
dependent upon the contents of another cell.

I can't find the solution. Does anybody know how I can do
this? Thanks.

 

[Dan E]

=SUM(INDIRECT("A" & (1+B1) & ":A" & (3+B1)))

Dan E

 

[Norman Harker]

Hi Jim!

Try:

=SUM(INDIRECT("A"&(1+B1)&":A"&(3+B1)))

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Tuesday 22nd July: Gambia (Liberation Day),
Poland (National Liberation Day), Slovenia (People's Uprising Day),
Swaziland (Birthday King Sobhuza II)
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.