ranges

F

Filipemr

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

pinmaster

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

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

HTH
JG
 
Top