Using Values to Refrence Cells

[RandomWa1k]

Not sure if this is possible, but I want to be able to use the value in a cell to reference another cell.

eg.

If the cell value is of c1=9 , I want my function to be =sum(a1:a9) where the 9 is the value from c1.

Thanks!

 

[jlbutcher]

To reference the cell value of C1 and place the value into A1
type =C1 into A1 cell. Not sure if this is what you are looking for? Where does A1 get its value?

 

[Sal Paradise]

There are several ways to do this, and you can use the help functions to further figure out which is best:

Excel Workbook
	A	B	C	D
1	#		Rows:	7
2	3		=OFFSET()	31
3	2		=INDIRECT()	31
4	3
5	9
6	6
7	7
8	1
9	5
10	9
11	3
Sheet1

(forgot to update a formula)

 

[dialup]

or

=SUM(A1:OFFSET(A1,C1-1,0))

 

[mikerickson]

or =SUM(OFFSET(A1,0,0,C1,1))