Something along these lines should suffice:

In C1: =SUMPRODUCT((A1:A20="Name1")*(B1:B20=0))

Use the smallest range sufficient
to cover the max expected extent of data in cols A and B
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"dsk3808" wrote:
I need to count the number of times a person, who's name is in column A, has
a specific value,"0", in column B, where the worksheet contains an
ever-increasing amount of records (rows). Is there an easy way to make this
happen? Any help is appreciated. Thanks