Craig,

Use the INDIRECT function to convert a text string in to an
actual range address:

=COUNTIF(INDIRECT("B1:B"&A1),"0")

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Craig" wrote in message
...
How can I change the cell ref of a formula to one that is
stored in another
cell?
e.g. I want to do a

COUNTIF(B1:B*x*,"0")

where the value of *x* has been manually input in A1

TIA
Craig