I am still working on a Plan vs Actual Date chart
I'm trying to compare the Plan Date and the Actual Date
=IF(SUMPRODUCT(--(Odyssey!$E$2:$E$998=A12),--(Odyssey!$AN$2:$AN$998=B2),--
(Odyssey!$AO$2:$AO$998<""))<0,SUMPRODUCT(--(Odyssey!$AN$2:$AN$998=B2),--
(Odyssey!$AO$2:$AO$998<"")),"")
A12 is the name of the business unit
B2 is the date of tha month
AN is Plan Date
AO is ACtual Date
The problem is that I'm getting a double counts. Any suggestions?
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200608/1