Array Formulas and Named Ranges

I have two named ranges, timeInA_D and timeOutA_D. Both ranges are the same size, 60,000 rows. I am trying to evaluate how many of the cells in timeInA_D are between 6:55 AM and 7:00 AM.

I'm using the array formula

{=COUNT(IF(AND(timeInA_D<A1,timeInA_D>A2),1,FALSE))}

where A1 and A2 are 7:00 AM and 6:55 AM.

The result of this count is "1". That is definitely not the right answer. Can anyone see what is wrong with my formula or another way of calculating this?

Thanks

=sumproduct((timeInA_D<A1)*(timeInA_D>A2))

Does that work? if not ate the times actually part of a date and so not in the range.

Regards

Dav

Easier to go with Dav's SUMPRODUCT suggestion, I think, but you could make your array formula work like this

=COUNT(IF(timeInA<A1,IF(timeInA>A2,1)))

You can't use AND with these type of fomulas because that will return a single result rather than an array....

I suspect you want <= and >= as comparison operators.