Sumif for range of time

[30percent]

=Sumif(B:B, "(>5/31/2011 5:00:00 PM) AND (<5/31/2011 11:59:59 PM)", E:E)

Hi,

on column B, I have TIME OF ORDER PLACED, and on column E, I have Quantity of Order. I tried to sum up the amount of orders placed from 5pm to 11:59pm using the formula above but I'm getting zero as a result. Can anyone please point out, why the formula is not working or why it is summing to zero?

type of data I have on column B is 5/31/2011 5:00:00 PM.
type of data I have on column E is 1000

Thank you for your help!

 

[barry houdini]

You can't use AND in SUMIF but you could use two SUMIF formulas like this, i.e. specifically for those time periods try

=SUMIF(B:B,">5/31/2011 5:00:00 PM",E:E)-SUMIF(B:B,">=6/1/2011",E:E)

or if all the values are on that date prehaps just sum the rows where the hour is >=17, i.e.

=SUMPRODUCT((HOUR(B2:B100)>=17)+0,E2:E100)

 

[30percent]

Thank you for your help!!!