| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| assign formula to another cell | Excel Worksheet Functions | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
Linear Mode
