I need to count the number of names in a very long list
complaring excel columns that are titles name and date. I
would like the formula to count all DISTINCT names on EACH
given date giving me a grand total of names.
EXAMPLE

James Smith June 12, 2004
James Smith June 12, 2004
Mike Black June 12, 2004
Karen Jones June 13, 2004
Mike Black June 13, 2004
Jane Smith June 13, 2004

Total Count: 5

I appreciate the help.

Thank you.