View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matthew Pfluger Matthew Pfluger is offline
external usenet poster
 
Posts: 130
Default EOMONTH not allowed in Array Functions?

I'm trying to use EOMONTH in an array function using a named range as
EOMONTH's first input:

=SUM(N(EOMONTH(rgnEndDate,0)=EOMONTH($A2,0))*rgnHo urs)

The function is giving me a $NAME error even though the Analysis Toolpak is
installed. Can anyone please verify this error for me or correct my error?

Thanks,
Matthew Pfluger