Variable Cell Refs
 

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

Variable Cell Refs
 

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

Variable Cell Refs
 

Try with

=COUNTIF(B1:INDEX(B:B, A1); "0")

--
Regards,

Juan Pablo González

"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