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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Question on the countif function and times
Why aren't your ranges the same?
-- __________________________________ HTH Bob "MTSkibum" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Question on the countif function and times
they were the same, i was using 1-500, but right before i copied and pasted i
tried to change it to 238 to make it match the text i typed in. In the file they are the same, and it reads 1-500, although there are only 238 entries. "Bob Phillips" wrote: Why aren't your ranges the same? -- __________________________________ HTH Bob "MTSkibum" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Question on the countif function and times
I think your first formula is correct and you may be getting a good answer,
bt it is being formatted as time. Try this, in a completely new cell =N(COUNTIF(G1:G500,"12:01")-COUNTIF(G1:G500,"12:10")) -- __________________________________ HTH Bob "MTSkibum" wrote in message ... they were the same, i was using 1-500, but right before i copied and pasted i tried to change it to 238 to make it match the text i typed in. In the file they are the same, and it reads 1-500, although there are only 238 entries. "Bob Phillips" wrote: Why aren't your ranges the same? -- __________________________________ HTH Bob "MTSkibum" wrote in message ... 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 |
Reply |
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 |