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

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.

Roger

Try:

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

Regards

Trevor


"RogerBarker" wrote in 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.

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

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"RogerBarker" wrote in 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.

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