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

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

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

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


--
kraljb
------------------------------------------------------------------------
kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955
View this thread: http://www.excelforum.com/showthread...hreadid=552448

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

I'll try that, thank you so much.
--
Glenda


"kraljb" wrote:


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


--
kraljb
------------------------------------------------------------------------
kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955
View this thread: http://www.excelforum.com/showthread...hreadid=552448