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

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


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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
>