Thread: Using COUNT for dates and times
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Carim Carim is offline
external usenet poster
  
Posts: 510
Default Using COUNT for dates and times
Hi,

Give a try to following :

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

HTH
Cheers
Carim

Reply With QuoteReply With Quote