Average with 3 conditions

[nelsok]

{=AVERAGE(IF(AND($B$2:$B$857=1,E2:E857<DATE(2006,3,1),E2:E857>=DATE(2006,2,1)),$F$2:$F$857))}

I am trying to average cells f2:f857
if the correspoding cells in b2:b857 = 1
AND
E2:E857 is less than 03/01/2006
AND
E2:E857 is greater than or equal to 02/01/2006


b:b contains numbers 1 through 7
e:e contains dates
f:f contains times



any idea what is wrong with my formula and how to fix it?

 

[Aladin Akyurek]

Only problem with getting rid of the hours is that they are significant to the stats I am creating

Never mind the hours that are significant are in the cells i am averaging.


thanks for the help.

I'm confused by your reply: Can we ignore the time bit in average calculation?