One mo

=sumproduct(--(text(a1:a100,"mmddyyyy")="08222009"))

Adjust the ranges to match--but you can't use whole columns (except in xl2007).

=sumproduct() likes to work with numbers. The -- stuff changes trues and falses
to 1's and 0's.

Bob Phillips explains =sumproduct() in much more detail he
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

And J.E. McGimpsey has some notes at:
http://mcgimpsey.com/excel/formulae/doubleneg.html

===============
I think I'd consider using a pivottable, too.

You could group by date (and ignore the time).

count celld with date and time wrote:

Hi, could somebody please help!

cell contain date and time
e.g. " 22/08/2009 14:34"

loads of them in the same column lets say column "A"

I have 5000+ cells per day transfered from another system,

I need to know everyday, how many of these 5000 cell iin column A is from
22/08/2009, 23/08/2009, 24/08/2009....etc (can ignore the time)

I have tried using formula
=SUM(COUNTIF(A:A,{"22/08/2009"}))

but it does not work, as the time within the cell is causing non exact
match, is there a way to go round this, and count how many cells is from each
date?
I have formated the cell to show dates only but the cell still contain time,
and still does not work!

all your help is greatly appreciated, thx a million

--

Dave Peterson