ranges
 

I want to index a range to other cell. or to a number. eg. sum(a1:a10), but
indexed to other cell or number, like sum(a1:a1+9). what function can i use?
a1+9, must be a10.

ranges
 

Hi,
You can use the INDIRECT function:
=SUM(A1:INDIRECT("A"&B1))
use B1 to enter a row number for your range.
or

=IF(B10,SUM(A1:INDIRECT("A"&B1)),"")

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=488500