Using countif

[tennrlp]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

I have a number of events that have a date and time, I would like to count how many happened in a day so I can track it on a monthly chart. Example

5/1/09 12:30
5/1/09 1:32
5/1/09 3.04
5/2/09 5:34

What I want is one column with 5/1/09 counting 3 and 5/2/09 counting 1

I have tried =countif($b$1.$B$100, "5/1/09*") I get zero for the answer. I have tried to format either or both to general text.

Thanks for your help

 

[Carl Witthoft]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

I have a number of events that have a date and time, I would like to count
how many happened in a day so I can track it on a monthly chart. Example

5/1/09 12:30
5/1/09 1:32
5/1/09 3.04
5/2/09 5:34

What I want is one column with 5/1/09 counting 3 and 5/2/09 counting 1

I have tried =countif($b$1.$B$100, "5/1/09*") I get zero for the answer. I
have tried to format either or both to general text.

Thanks for your help

I'm assuming you meant =countif($b1:$b100 .... ( colon, not period).
But even then, if your dates are dates and not text strings, then you
don't want to compare to a quoted string. Probably something like

=COUNTIF(b1:b100,AND(>4/30/09,<5/2/09)) might work (where the AND
function guarantees the date is after april 30 but before may 2,
regardless of the time of day)