If your dates are in column A and times in column B

=SUMPRODUCT(--(A1:A100="07/01/06"+0),--(HOUR(B1:B100)=10))

for a count.

to sum column C where these criteria apply

=SUMPRODUCT(--(A1:A100="07/01/06"+0),--(HOUR(B1:B100)=10),C1:C100)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=570571