Adjustable rows via a separate cells

[keen2xl]

Hi

Need to adjust the length of a countif formula from a separate cell

something like this ?

=COUNTIF($BB$23:$BBH21),">0")

H21 being the cell i will change value to indicate rows

Cheers Men

[benishiryo]

hi there. so if H21 contains the value 25, then it's:
=COUNTIF(INDIRECT(BB21:BB25,">0")

if so, then:
=COUNTIF(INDIRECT("BB21:BB"&H21),">0")

or:
=COUNTIF(BB21:INDEX(BB:BB,H21),">0")

INDIRECT is slightly volatile. wouldn't vary much if you're not using it extensively.

[keen2xl]

Cool

Ooh sorry about this but what if i wanted to change starting position too

Cheers