| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
COUNTIF WITH NAME A RANGE OF INFORMATION
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| print only range that contain information in excel 2007 | Excel Discussion (Misc queries) | |||
| Help with Macro that searches a Range for specified information | Excel Programming | |||
| COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
| How can I sum information in a list with a date range? | Excel Worksheet Functions | |||
| Preserve a range information | Excel Programming | |||
Threaded Mode
