EOMONTH not allowed in Array Functions?

M

Matthew Pfluger

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))*rgnHours)

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
 
B

Bob Phillips

You are absolutely correct.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

EOMONTH compatibility issue (workaround?) 1
ATPVBAEN Problems 20
EOMONTH to compare two dates (Excel 2003) 4
EOMonth Error - odd Excel 2003 behaviour 1
Help on EOMONTH error (have Analysis Pak installed) 3
Range properties from Array variables 2
Array in User Function 2
Alternative to Application.Caller in array functions to avoid wrong results? 10

Top