B
Barb Reinhardt
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_Date>F$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
a value error.
This is what I have
=SUMPRODUCT(--('2009'!Region_All=$A31),--(IF(ISNUMBER('2009'!Due_Date),--('2009'!Due_Date>F$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