more sum product

[s2m via OfficeKB.com]

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?

 

[Bob Phillips]

Shouldn't you be using

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Bob Phillips]

Shouldn't you be using

=IF(SUMPRODUCT(--(Odyssey!$E$2:$E$998=A12),--(Odyssey!$N$2:$N$998=B2),--
(Odyssey!$O$2:$O$998<>""))<>0,SUMPRODUCT(--(Odyssey!$E$2:$E$998=A12),--(Odys
sey!$N$2:$N$998=B2),--
(Odyssey!$O$2:$O$998<>"")),"")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[s2m via OfficeKB.com]

not to be funny but what should I use?

Shouldn't you be using

=IF(SUMPRODUCT(--(Odyssey!$E$2:$E$998=A12),--(Odyssey!$N$2:$N$998=B2),--
(Odyssey!$O$2:$O$998<>""))<>0,SUMPRODUCT(--(Odyssey!$E$2:$E$998=A12),--(Odys
sey!$N$2:$N$998=B2),--

I am still working on a Plan vs Actual Date chart

[quoted text clipped - 10 lines]

The problem is that I'm getting a double counts. Any suggestions?

 

[s2m via OfficeKB.com]

OK I got it, I need to add the condition (Odyssey!$E$2:$E$998=A12)

Thanks

You have been such a great help to me!

not to be funny but what should I use?

Shouldn't you be using

[quoted text clipped - 8 lines]