Variable Cell Refs

C

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
 
C

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
 
Top