Countif.

[GEM]

I want count the ammount of times that a name comes up in a given day, for
example,

A B
1 July 20, 2009 John Doe
2 July 20, 2009 Jane Doe
3 July 28, 2009 John Doe
4 July 28, 2009 John Doe
5 July 28, 2009 Jane Doe
6 July 28, 2009 Jane Doe
7 July 28, 2009 Jane Doe

On July 20, 2009
John Doe - 1
Jane Doe - 1

On July 28, 2009,
John Doe - 2
Jane Doe - 3


What function can I use??

 

[Jim Thomlinson]

Same as the last formula but without the last part...

=SUMPRODUCT((Sheet1!A$1:A$100=A$1)*(Sheet1!B$1:B$100=A2))