variable cell reference

  • Thread starter Thread starter Jim B
  • Start date Start date
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.
 
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.
 
Back
Top