Check to ensure there is no discrepancy between dates. 1/1/2006 12 AM and
1/1/2006 1 AM formatted just to show the day is a different number.
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"s2m via OfficeKB.com" wrote:

I am trying to count the number of plan dates (column Z) to Actual Dates
(column AA). H2 is the date cell.

The below formula give me the count of 16 which is right
=SUMPRODUCT(--(TCS!$E$2:$E$1000="GDS"),--(TCS!$Z$2:$Z$1000=H2))

Give me a number of 44 which is not right, it should be 12.
=IF(SUMPRODUCT(--(TCS!$E$2:$E$1000="GDS"),--(TCS!$Z$2:$Z$1000=H2),--(TCS!$AA
$2:$AA$1000<""))<0,SUMPRODUCT(--(TCS!$Z$2:$Z$1000=H2),--(TCS!$AA$2:$AA
$1000<"")),"")

I've been scratching my head for a few hours, not sure what to do.

Thanks again

s2m

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200607/1