Posts by trydon

Re: Sumif wildcard help! (DAte/time)

Thank you I will try this later

Re: Sumif wildcard help! (DAte/time)

Sorry i use 2003, and sumifs does not work. any other solution?
is it possable to recreat this in VBA?

Re: Sumif wildcard help! (DAte/time)

Quote from etaf;658187

not sure about the wild card
but you could try
=SUMIFS(Data!Q:Q, Data!P:P ,">=5/4/13 00:00", Data!P:P ,"<=5/4/13 23:59:59")

Sorry but this comes up with an error. (because of SUMIFS not SUMIF). but when i change it to SUMIF i still get a formattign error. not sure you can put ,"<=5/4/13 23:59:59")

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]

[/tr]

[tr]

[td]

05/04/2013 14:50

[/td]

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

[/tr]

[tr]

[td]

05/04/2013 15:00

[/td]

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

[/tr]

[tr]

[td]

05/04/2013 15:10

[/td]

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

[/tr]

[tr]

[td]

05/04/2013 15:20

[/td]

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

[/tr]

[tr]

[td]

05/04/2013 15:30

[/td]

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

[/tr]

[tr]

[td]

05/04/2013 15:40

[/td]

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

[/tr]

[tr]

[td]

05/04/2013 15:50

[/td]

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

[/tr]

[tr]

[td]

05/04/2013 16:00

[/td]

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

[/tr]

[tr]

[td]

05/04/2013 16:10

[/td]

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

[/tr]

[tr]

[td]

05/04/2013 16:20

[/td]

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

[/tr]

[tr]

[td]

05/04/2013 16:30

[/td]

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

[/tr]

[tr]

[td]

05/04/2013 16:40

[/td]

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

[/tr]

[tr]

[td]

05/04/2013 16:50

[/td]

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

[/tr]

[tr]

[td]

05/04/2013 17:00

[/td]

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

[/tr]

[tr]

[td]

05/04/2013 17:10

[/td]

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

[/tr]

[tr]

[td]

05/04/2013 17:20

[/td]

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

[/tr]

[tr]

[td]

05/04/2013 17:30

[/td]

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

[/tr]

[tr]

[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!