I would like to use the value in e.g. cell A1 (Value = 3) and cell A2 (Value
=44).

I want those values to be used in a formula e.g.
=COUNTIF(Q{Value in Cell A1}:Q{Value in Cell A2},"<9")
-- so the program would read:
=COUNTIF(Q3:Q44,"<9")

Is there any way to do this?

Glenda