Counting Functions

D

DLZ217

I can't seem to figure out how to count the number of times a date shows up
in a column, the data is entered in this format 05/05/2005 for instance and
when I type that date I want to count it defaults to 5/5/2005 so I tried to
change the original data to that format but it still doesnt seem to work, any
ideas? Thanks!!

Mike
 
C

CLR

=COUNTIF(A:A,"05/05/2005")

or, put 05/05/2005 in cell F1 and use this........
=COUNTIF(A:A,F1)

Then all you have to do is change F1 if you want to count another
date..........


Vaya con Dios,
Chuck, CABGx3
 
Top