Variable Cell Refs

[Craig]

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

 

[Chip Pearson]

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

 

[Juan Pablo Gonzalez]

Try with

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