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

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

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

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