Using COUNT for dates and times

[Guest]

There are 3 ocurrences of 'Adams' in A1:A19 and 3 occurrences of '08:00:00'
(in time format) between C1:C19, linked to Adams. There is one occurrence of
Adams - 08:15:00:00 between A1:A19 and C1:C19.

What function and formula would I use in A20 to return a value of 3 (i.e. to
count the Adams at 08:00:00 occurreces)?

If I wanted to count Adams (Column A) and (in date format) say, 27/9/06 (in
column B), would I use the same formula?

 

[Carim]

Hi,

Give a try to following :

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

HTH
Cheers
Carim

 

[Bob Phillips]

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]

Hi Bob,


Thanks for correcting my mistakes ...
I should have been more attentive ...

Carim

 

[Guest]

Bob,

Many thanks for your help - it works perfectly!

Tony

 

[Guest]

Carim,

Many thanks for your help!

Tony