Cell Reference/Address

[YZ]

How can I reference a cell based on the contents of another cell e.g.:-

=sum(A1.Ax) where *x* is a value contained in another cell ( in D3
for example).

Many TIA
YZ

 

[Bob Phillips]

=SUM(INDIRECT("A1:a"&D3))

 

[Aladin Akyurek]

Another...

=SUM(A1:INDEX(A:A,D3))