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