countif using a cell for range

[cmb80]

Hi All, I want to count a range. But instead of using

Please Login or Register  to view this content.

I want the 480 to be determined by a cell. Cell B5 in fact. So if B5 = 550 the countif would be

Please Login or Register  to view this content.

Please help to advise

[DBY]

Hello
Try using the INDIRECT function, for example:

Please Login or Register  to view this content.

DBY

[Kramxel]

try:

Please Login or Register  to view this content.

[FlameRetired]

Another way if you also need to avoid the volatility of INDIRECT :

Please Login or Register  to view this content.

I chose row 10000 assuming it to be suitably large enough for an upper boundary. That can be changed to a larger number if needed. Or use the whole column Y in this way :

Please Login or Register  to view this content.