Using cell value in range reference

[Sandy]

I have a value of 20 in cell A1, how can I use this value in a formula.

E.g. COUNTA("D11" & A1) - (I feel it should be similar to this )

Sandy

 

[Don Guillett]

=COUNTA(INDIRECT("D11"&a1))

 

[Roger Govier]

Hi Sandy

One way
=COUNTA(D11:INDEX(D,A1))

 

[Don Guillett]

another
=COUNTA(D11:OFFSET(D11,0,0,a1))

 

[Sandy]

Don, Roger,

Thank you once again; as usual there is never just one way to do these
things, which always makes it very interesting to see the variety of the
solutions.

Sandy

 

[Sandy]

Don

This one seems to count from D1130, whereas I was looking to count from
D1120.
I think it may be offsetting from the 11th row by the value of A1; 20 in my
case.

Sandy

 

[Jeffri Huang]

Try COUNTA("D11" & $A$1)