Possible to reference column of named range in array formula?

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" <[email protected]> wrote in message
news:[email protected]...
> 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]" <[email protected]> wrote in message
news:s%[email protected]...
> 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.