PDA

View Full Version : Solved: Sumproduct calculating total incorrectly due to date



Nurofen
06-04-2010, 05:23 AM
Hi,

I have tired for a few days but unable to work it out -

the amount of times CarandRoad appears between
29/06/2010 - 31/06/2010 = 359

when i use the date
29/06/2010 - 04/06/2010 = 339 it should still be 359

Could anyone explain why this is happening and what i'm doing wrong.

Regards

Nurofen

mdmackillop
06-04-2010, 05:48 AM
Looking at the individual results, they seem to be correct.

Bob Phillips
06-04-2010, 06:28 AM
The one you mark as incorrect looks fine to me, I pivotted the data and got that answer, but the other seems to be counting 5 too many, the five in July 2010.

Nurofen
06-04-2010, 06:46 AM
i'm going to re-check the data and i'll post back

arthurbr
06-04-2010, 06:52 AM
Your problem is that June 31st does not exist and is treated as text by XL

Bob Phillips
06-04-2010, 07:40 AM
Your problem is that June 31st does not exist and is treated as text by XL

Exactly, but the OP thinks that one is correct and the other is not!

Nurofen
06-04-2010, 09:13 AM
all,

I can see where i went wrong thanks for your help.