Is it possible to use EOMONTH as a test
criteria in a sumproduct array?

Yes, but EOMONTH won't work on arrays.

This *won't* work:

=SUMPRODUCT(--(A1:A10=EOMONTH(A1:A10,0)))

This will work:

=SUMPRODUCT(--(A1:A10=EOMONTH(B1,0)))

--
Biff
Microsoft Excel MVP


"ocuhcs" wrote in message
...
Is it possible to use EOMONTH as a test criteria in a sumproduct array?

I have the EOMONTH set up as column headers on my worksheet to show a 7
month window of data (3 months prior, current month, and 3 months future),
this will always be current based on the current date. I want to pull data
from a separate work sheet based on monthly totals, but I would like to
incorporate the EOMONTH formula into the sumproduct so the data stays
current
with the column headers.