| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF doesn't work
I want col. "E" to count how often col "C" <=24hrs for each of the 12 months
A B C D E Date & time Date & Time Elapsed time Time <= 24:00hr TALLY Rec'd Needed 1/2/'09 13:00 1/3/'09 09:00 20hrs JAN 2 1/2/09 14:00 1/3/'09 10:00 20hrs FEB 0 1/2/09 14:00 1/4/'09 14:00 48hrs MAR 0 2/2/'09 09:00 2/2/'09 10:00 25hrs The solution evades me. -- Thanks Ken |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to get Countif to work this out? | Excel Worksheet Functions | |||
| Countif does not work | Excel Worksheet Functions | |||
| CountIf should work across sheets | Excel Worksheet Functions | |||
| SUMPRODUCT vs. COUNTIF -- Why does one work? | Excel Worksheet Functions | |||
| countif(a1:a12,">TODAY()") How do I get this to work? | Excel Worksheet Functions | |||
Threaded Mode
