COUNTIF to be used with a time range

J

jpsabourin

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
 
R

Roger Govier

Hi

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COUNTIF WITH NAME A RANGE OF INFORMATION 7
Countif with parameters from another range? 4
Countif with Named Range 3
Excel Use COUNTIF across a range of cells with formulas 0
Change "Text Like" to "Greater than" 3
Countif time syntax 6
Problem using multiple criteria to get a count 1
COUNTIF using amount of time 3

Top