Hello I have been having a huge problem tryign to get Sumif to work correctly.

Here is my data below Columns P is date and time and column Q is Actual Qty.

[TABLE="width: 233"]

[tr][td]Time

[/td][td]Actual

[/td][/tr]

[/TABLE]

[TABLE="width: 233"]

[tr][td]05/04/2013 14:40

[/td]

[TD="align: right"]96[/TD]

05/04/2013 14:50

[/td]

[TD="align: right"]96[/TD]

05/04/2013 15:00

[/td]

[TD="align: right"]64[/TD]

05/04/2013 15:10

[/td]

[TD="align: right"]32[/TD]

05/04/2013 15:20

[/td]

[TD="align: right"]128[/TD]

05/04/2013 15:30

[/td]

[TD="align: right"]96[/TD]

05/04/2013 15:40

[/td]

[TD="align: right"]128[/TD]

05/04/2013 15:50

[/td]

[TD="align: right"]96[/TD]

05/04/2013 16:00

[/td]

[TD="align: right"]64[/TD]

05/04/2013 16:10

[/td]

[TD="align: right"]32[/TD]

05/04/2013 16:20

[/td]

[TD="align: right"]32[/TD]

05/04/2013 16:30

[/td]

[TD="align: right"]96[/TD]

05/04/2013 16:40

[/td]

[TD="align: right"]128[/TD]

05/04/2013 16:50

[/td]

[TD="align: right"]96[/TD]

05/04/2013 17:00

[/td]

[TD="align: right"]64[/TD]

05/04/2013 17:10

[/td]

[TD="align: right"]64[/TD]

05/04/2013 17:20

[/td]

[TD="align: right"]128[/TD]

05/04/2013 17:30

[/td]

[TD="align: right"]128[/TD]

05/04/2013 17:40

[/td]

[TD="align: right"]32

[/TD]

[/tr]

[/TABLE]

Here is my sum if statment to count the quality within each hour. (i have many of these for 24 hours)

=SUMIF(Data!P:P,"05/04/****13:**",Data!Q:Q)

Im not sure why this does not work, if i type the date and tiem in in full it works. but wildcards do not work. Im confused why.

Hope you can help!