"T. Valko" wrote...
....
Your array formula will work like this:

=SUM((B$1:B$10=--"3/10/2007")*(C$1:C$10=--"6:00 AM"))
....

And if the col B values are integers,

=COUNT(1/(B$1:B$10+C$1:C$10=--"3/10/2007 6:00 AM"))