COUNTIF WITH NAME A RANGE OF INFORMATION
Hi
I answered your earlier posting.
You have now changed the requirement.
Enter lowest time in E1, largest time in F1
=SUMPRODUCT(($B$1:$B$1000=E1)*($B$1:$B$1000<=F1)* ($A$1:$A$1000="fast"))
For your future reference, it is better to keep to the original posting,
varying the parameters, rather than starting a new thread.
--
Regards
Roger Govier
wrote in message
oups.com...
I am currently using this formula in
=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 as well, example..
Cell A1 to A1000 have various names and one of the them is "Fast".
Cell B1 to B1000 have the delivery times.
I need to have a cell in my report COUNT the number of deliveries in
Column B that were between 00:01 to 00:05 minutes from the service
Fast in Column A
Column A has the name of the service
Column B has time range for the deliveries
Thanks
JP
|