variable cell reference

J

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.
 
N

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)
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top