COUNTIF to be used with a time range
 

I am currently using this formula

=COUNTIF($F$6:$F$1194,"Fast") to count cells with the word "Fast", but
how do we set it up to give a time range, example..

Calls between 00:01 to 00:05 minutes ?

Thanks
JP

COUNTIF to be used with a time range
 

Hi

Put the lower time in A1, the larger in B1 and use

=SUMPRODUCT(($F$6:$F$1194=A1)*($F$6:$F$1194<=B1))

--
Regards

Roger Govier


wrote in message
oups.com...
I am currently using this formula

=COUNTIF($F$6:$F$1194,"Fast") to count cells with the word "Fast", but
how do we set it up to give a time range, example..

Calls between 00:01 to 00:05 minutes ?

Thanks
JP