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