Making an internal function max range, = an external number

[Travis Kunnen]

Hello All

My problem now is the below.

=COUNTIF($H$106:$H$605;"POS")

I am trying to count a range of data that contains POS, but the max range for each column changes each time. So I manually have to change the $605 to, 302, or 120, or 622.
Is there any way I can link the max range $H$605, to an external number in a cell, so that the 605 automatically changes when I change the external number?

 

[Peter_SSs]

Glad you got it sorted.

Just had to play around with the colons and comma's.
=COUNTIF($H$136:INDEX($H:$H;$W$67);"POS")

The required swap was just as I suggested in posts 2 and 4

(You'll have to substitute ";" for my ",")

Do you need to swap ";" for where I have ","?