Use INDIRECT:

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

HTH
Jason
Atlanta, GA

-----Original Message-----
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.
.