Put your unique nos in Col C
then enter this in D1 and copy down
=IF(SUMPRODUCT(--($A$1:$A$100=C1),--($B$1:$B$1000))0,SUMPRODUCT(--($A$1:$A$100=C1),--($B$1:$B$100=0)),0)

Adjust 100 to the end of your data set.

"force530" wrote:

Column A contained a unique identifier for each record. I want to be able to
count the number of records with 0's, if a date is also recorded for the same
unique number. Ex: A1, A2, A3 is record 960. A1 has a date, A2 and A3 are
0's. The answer I am looking for would be "2". A8 and A9 is 522. The answer
would be 1.

In the end the final number I am looking for is the sum of 2 and 1, "3".

A B
1 960 7/22/2004
2 960 0
3 960 0
4 967 0
5 990 8/7/2008
6 12 2/6/2007
7 43 10/16/2008
8 522 8/29/2008
9 522 0
10 174 2/28/2007