Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Question on the countif function and times
I need to count all the times between 12:01 am and 12:10 am in a collumn, i
have been messing around with variations of the formula, i have even tried to use cells to hold 12:01 and 12:10, but that didnt work either. =COUNTIF(G1:G500,"12:01")-COUNTIF(G1:G238,"12:10") with this equation i get a 0 value =COUNTIF(G1:G500,"12:01")-COUNTIF(G1:G238,"<12:10") with this formula i get an answer of -238, ie the negative value of the number of total entries thanks for any help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
function question (sumif countif conditional) | Excel Worksheet Functions | |||
countif function question | Excel Worksheet Functions | |||
A question about the Count/CountIf function | Excel Worksheet Functions | |||
CountIf Function Question | Excel Discussion (Misc queries) | |||
Countif/Sumif function question | Excel Worksheet Functions |