Is it Possible in a formula to have a formula for cell reference?

[Guest]

Excel Users,

Is something like this possible in a cell:

COUNTA(B3:B(C47))

This doesn't work for me if I put a number in C47.

Thanks for any help.

 

[Trevor Shuttleworth]

Roger

Try:

=COUNTA(INDIRECT("B3:B"&C47))

Regards

Trevor

 

[Ken Wright]

Take a look at the INDIRECT function that allows you to build a reference
with strings and numbers.

=COUNTA(INDIRECT("B3:B"&C47))

 

[Jason Morin]

Use INDIRECT:

=COUNTA(INDIRECT("B3:B"&C47))

HTH
Jason
Atlanta, GA