contents of cell referenced into formula

[Dave the Man]

I am trying to reference the content of a cell into a formula.
For example:

I type i6 into b2, and i20 into b3.
I then type a formula elsewhere which looks at what is entered into b
and b3, and inserts the contents (ie. i6 and i20) as a range...

I want the formula
=countif(b2:b3,">0")
to actually do
=countif(i6:i20,">0")

but, I want it to reference the contents so that i can change b2 and b
and the formula will automatically adjust and work out the new range.

Can anyone help me with this please? Thanks

 

[Laura Cook]

Try the following:

=COUNTIF(INDIRECT(B2&":"&B3),">0")