You are absolutely correct.

=SUMPRODUCT(--(DATE(YEAR(rgnEndDate),MONTH(rgnEndDate)+1,0)=EOMO NTH($A2,0)),rgnHours)

--
__________________________________
HTH

Bob

"Matthew Pfluger" wrote in
message ...
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