contents of cell referenced into formula

  • Thread starter Thread starter Dave the Man
  • Start date Start date
D

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
 
Back
Top