Use the value in a cell in a formula in another cell

[Glenda]

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

 

[kraljb]

Use the INDIRECT Formula, it should take care of your problems.

 

[Glenda]

I'll try that, thank you so much.