Can you upload your sample file/data using a free filehost,
post a link to it here

Eg, you could use this free filehost:
http://www.freefilehosting.net/

Copy the "direct link" generated after you upload,
then paste it here
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Ann" wrote in message
...
i have this:
=SUMPRODUCT((I6:I402<"")*(M6:M402<""))-SUMPRODUCT((I6:I402=--A1)*(I6:I402<=--A2)*(M6:M402=--A1)*(M6:M402<=--A2))

this is giving me a much larger # than i expect. i want it to search M
for
dates within 5/19 and 5/22, compare them to dates in I with the same
dates,
and return a result, if the date in M date in I. apologies if i worded
it
wrong.