If I have an array formula something like this:

=SUM(1*(BA20<$BA$19:$BA$755))

Is there a way to obtain a reference to a specific column in a named range
and use that instead of hardcoding the column range? I'm thinking of
something like this (which I know is wrong but should illustrate what I'm
trying to do):

=SUM(1*(BA20<NamedRange.Column(3)))

Is this sort of thing doable?

Thanks.

-------------------------------------------------------------
Kel Good
MCT, MCAD, MCSD for Microsoft.NET

You could try something like

OFFSET(teams,0,2,,1)

which gets the third column by virtue of the 2

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Kel Good" wrote in message
...
If I have an array formula something like this:

=SUM(1*(BA20<$BA$19:$BA$755))

Is there a way to obtain a reference to a specific column in a named range
and use that instead of hardcoding the column range? I'm thinking of
something like this (which I know is wrong but should illustrate what I'm
trying to do):

=SUM(1*(BA20<NamedRange.Column(3)))

Is this sort of thing doable?

Thanks.

-------------------------------------------------------------
Kel Good
MCT, MCAD, MCSD for Microsoft.NET

Hi Kel,

Did Bob's suggestion help you?
If you still have any concern, please feel free to post here.

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

Peter,

I got an offline mailing from Kel saying that it looked good.

Regards

Bob


""Peter Huang" [MSFT]" wrote in message
...
Hi Kel,

Did Bob's suggestion help you?
If you still have any concern, please feel free to post here.

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no
rights.

Hi Bob,

Thanks for your response.

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.