I don't think Excel is seeing 01/01/2008 02:23.01 PM is a real date... the
decimal point in the number of minutes(?) is not standard, so Excel is not
recognizing it as a date, rather, it is seeing it as text, so your date
comparisons are failing. If you select one of the cells with this "date" in
it, look at the formula bar... you should see an apostrophe in front of the
entry. You will need to convert these to real dates for your SUMPRODUCT to
work; or you will have to change your SUMPRODUCT to do a text type
comparison.

Rick


wrote in message
...
I have a sumproduct equation which I've used in the past and it works
great, but I've applied it to another application and now I it's
having trouble with matching dates. I pull information from a access
table onto a worksheet. the date (transaction date) reflects as
01/01/2008 02:23.01 PM. I have another sheet that has everyday of the
a month on it, so one sheet would be all of january, sheet 2 would be
Feb, sheet 3 Mar, etc. all with dates on it. The sumproduct equation
would match the 5 criteria (which works already except for matching up
dates) and put the correct volume with the correct day in the month
sheets.

As the headers of the months I have the dates listed as 01/01/008,
01/02/2008.....1/31/2008 with no time. The sumproduct seems to be
stuck on matching the date formats up. I did isnumber on both and both
are numbers.


=SUMPRODUCT(--(1*'Pulled from Access'!$B$7:$B$5420=Period1!$C5), 'this
matches store #'
--(1*'Pulled from Access'!$C$7:$C$5420=Period1!
$D5), 'this matches item #'
--(1*'Pulled from Access'!$P$7:$P$5420=Period1!
C8), 'this matches date'
--('Pulled from Access'!$I$7:$I
$5420="R"), 'this matches received
voucher'
'Pulled from Access'!$G$7:$G
$5420) 'this pulls
correct volume'


Basically this equation states that the volume of the correct, item,
plant and date that meets the certain voucher number will get placed
in the the correct date in the month.

Can anyone help?

Ryan