View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kel Good Kel Good is offline
external usenet poster
 
Posts: 6
Default 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