countif using input cell as range depth

Lets say i have numbers in 5 columns H - M and the number to count in range is in AD3
is there a way to determin the range depth "$M$9" by using an input cell "AH3", so if i enter 100 in cell "AH3"
The formula will change from

=COUNTIF($H$2:$M$9,AD3)
To

=COUNTIF($H$2:$M$100,AD3)

Thanks
Nigel

I have searched the net for help with INDIRECT function without any luck so far

Nigel

I have searched the net for help with INDIRECT function without any luck so far
Nigel

I got it using =COUNTIF(H2:INDIRECT(CONCATENATE("L",$S$3)),O3) thanks for pointing me in the right direction Ali

Nigel

:ole: