| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using value stored in cell in formula
I am using the following formula
=COUNTIF(AU6.0,'I_O Summary'!B$1) AU6.0 is the name of range. One of the cells in the spreadsheet (in this case A2) contains the text AU6.0. Is there a way to use a reference to A2 in my COUNTIF function? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using value stored in cell in formula
=COUNTIF(INDIRECT(A2),'I_O Summary'!B$1)
Bob Umlas Excel MVP "Philip Gabe" wrote in message ... I am using the following formula =COUNTIF(AU6.0,'I_O Summary'!B$1) AU6.0 is the name of range. One of the cells in the spreadsheet (in this case A2) contains the text AU6.0. Is there a way to use a reference to A2 in my COUNTIF function? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| referencing to a sheet that it`s name is stored on a cell | Excel Worksheet Functions | |||
| Link to worksheet whose name is stored in another cell | Excel Worksheet Functions | |||
| Sort (parameter stored in cell) | Excel Worksheet Functions | |||
| Return to cell whose address is stored in different cell | Excel Discussion (Misc queries) | |||
| accessing an address stored in another cell | Excel Worksheet Functions | |||
Linear Mode
