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