I've got a fairly complicated sumproduct and I can't seem to get anything but
a value error.

This is what I have

=SUMPRODUCT(--('2009'!Region_All=$A31),--(IF(ISNUMBER('2009'!Due_Date),--('2009'!Due_DateF$3))))

The named ranges are dynamic ranges
I've got the region part working.
What I want to find is data in the range Due_Date that is than F3 and < F3
+ 2 months. I just can't figure it out. Also, in Due_Date, I've got
numerics and N/A.

Can Someone assist?

Thanks,
Barb Reinhardt