Can I Use A Count If Function With A Forward Slash?
Are the entries TEXT or are they true Excel dates/times? They look like true
Excel dates/times.
See if this works:
=SUMPRODUCT(--(INT(A1:A10)=DATE(2008,7,7)))
Note that with SUMPRODUCT you *can't* use entire columns as range references
unless you're using Excel 2007.
--
Biff
Microsoft Excel MVP
"mommy2kh" wrote in message
...
I am trying to use a Count If function on a string of data with dates. The
data is downloaded like this --
Column A
Row 1 7/7/2008 1:18:00 PM
Row 2 7/7/2008 12:34:00 AM
Row 3 7/8/2008 5:03:00 PM
I tried setting up my Count If like this to count how many occurances
there
are of the date July 7, but it isn't working --
=COUNTIF(A:A,"7/7/2008*")
Is it not working because of the forward slashes? I can change the format
of the cells to show "Jul-07 x:xx:xx PM" but I cannot get the actual data
to
change to help me with the Count If function. Any ideas?
|