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.