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

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

--
HTH...

Jim Thomlinson


"GEM" wrote:

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??