| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why doesn't the INDIRECT function work when nested in FREQUENCY?
When I use {=FREQUENCY(INDIRECT($A$1),Bin_Range)} I get a column of #REF!.
A1 can contain one of two valid range names. The frequency function works when either of the two are entered directly or even when an IF function replaces the INDIRECT function e.g. {=FREQUENCY(IF($B$1=1,Range1,Range2),Bin_Range)} In all cases the formulae are entered as array functions. Does anyone know why it doesn't work? Regards Phil |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Thinking that indirect should work | Excel Discussion (Misc queries) | |||
| Indirect - Why does it seem to only work sometimes? | Excel Worksheet Functions | |||
| INDIRECT function do not work when other file is closed | Excel Discussion (Misc queries) | |||
| nested Indirect to other WS | Excel Worksheet Functions | |||
| Does file need to be open for INDIRECT to another workbook to work | Excel Discussion (Misc queries) | |||
Threaded Mode
