Thnak you T.

I understand, but the formula dosn't count properly when I replace the 6:00
AM with 6:00 PM - still a single value (i.e. give me the total count of all
those entires where the date is "3/10/2007" and time is "6:00 PM").

Mark



"T. Valko" wrote:

any clues as to why this is happending?

Because the formula is written to check only a single specific time: 6:00
AM.

That's what you asked for in your original post.

There are better ways to do this. See your original post.

Biff

"NWO" wrote in message
...
I have the following array formula:
{=SUM((B$1:B$100=DATEVALUE("3/10/2007"))*((C$1:C$100)=TIMEVALUE("6:00
AM")))}. Works fine for AM time values, but when formula runs across a PM
time value in the range, its ignored - any clues as to why this is
happending?

Thank you.

Mark :)