countif problem

[vgirl76]

I have data where by the date range i want it to count up all the times between 2 min and 5 min

so i have the following formula: COUNT(IF(SACRN!$E:$E>=DATE(109,6,15),IF(SACRN!$I:$I,{">=0.00138888888",">=0.00347222222"})*{1,-1}))

But i only end up with value of 1.
Can someone please let me know what i am doing wrong?
I think it must be my date set up. When i had the formula just straight counting the time value it was working but I needed to added the date criteria.

thank you

 

[LxQ]

IF(SACRN!$I:$I, --doesn't this always evaluate to TRUE?

">=0.00138888888",">=0.00347222222" --maybe one of them should be a less then?

 

[barry houdini]

I'd use SUMPRODUCT

=SUMPRODUCT(--(SACRN!$E:$E>=DATE(109,6,15)),--(SACRN!$I:$I>=TIME(0,2,0)),--(SACRN!$I:$I<=TIME(0,5,0)))

Note: the whole column ranges will only work in Excel 2007. If you are using an earlier version the restrict the ranges.