Re: Sumif wildcard help! (DAte/time)
Thank you I will try this later
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;658187not 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"]
Time
[/td]Actual
[/td]
[/TABLE]
[TABLE="width: 233"]
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="align: right"]32
[/TD]
[/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!