Possible to reference column of named range in array formula?

[Kel Good]

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.

 

[Bob Phillips]

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)

 

[Peter Huang [MSFT]]

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.

 

[Bob Phillips]

Peter,

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

Regards

Bob

 

[Peter Huang [MSFT]]

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.