=SUMPRODUCT(--(A1:A100=--"2005-10-11"),--(B1:B100="John"))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"SE" wrote in message
...
I am a novice with excel and I need assistance creating a formula that
will
count the number of people that appear by date. How can I ask excel to
complete the following calculation: If the date is "10/11/05" count each
occurrence of "John"? Here is my data sample:

Completion Date Contact Type Person
10-11-2005 Letter John
10-12-2005 Mail Paul
10-11-2005 Mail Richard
10-11-2005 Letter Paul
10-12-2005 Letter Paul
10-12-2005 Letter Paul
10-12-2005 Letter Paul
10-12-2005 Mail Richard
10-12-2005 Letter Paul
10-11-2005 Mail Richard
10-12-2005 Mail Jim
10-12-2005 Letter Paul
10-11-2005 Letter John
10-11-2005 Letter John
10-11-2005 Letter David
10-12-2005 Mail Jim
10-12-2005 Mail David
10-11-2005 Letter Paul
10-11-2005 Mail John
10-11-2005 Mail Jim


Thanks for any assistance you can provide.