Col B are date formatted, col C are time formatted. Problem is formula won;t
work with PM values (i.e. 6:00 PM). Help!!!

Thanx.

NWO




"Harlan Grove" wrote:

"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"))