Bob,

Many thanks for your help - it works perfectly!

Tony

"Bob Phillips" wrote:

4 typos and a logic error

=SUMPRODUCT(--(A1:A19="Adams"),--(C1:C19=--"08:00:00"))


other part


=SUMPRODUCT(--(A1:A19="Adams"),--(B1:B19=--"2006-09-27"))
--


HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Carim" wrote in message
s.com...
Hi,

Give a try to following :

=SUMPRODUCT(--(A1:A19)="Adams"*--(C1:C19)="08:00:00")

HTH
Cheers
Carim