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

On Fri, 23 Feb 2007 01:10:00 -0800, Philip J Smith
wrote:

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


It works OK here. Could it be that your range name is referring to a closed
workbook?
--ron

Hi Ron.

No. The ranges are on the same worksheet as the Frequency analysis, thanks
for your response - please see my note about the named ranges being of
variable length using the offset function.

Regards

Phil

"Ron Rosenfeld" wrote:

On Fri, 23 Feb 2007 01:10:00 -0800, Philip J Smith
wrote:

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


It works OK here. Could it be that your range name is referring to a closed
workbook?
--ron

Phil,
Works OK for me. Just check range name in A1 is correct as this
will give a #REF! error if incorrect.

"Philip J Smith" wrote:

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