Look at Jon Peltier's page on dynamic charts

http://peltiertech.com/Excel/Charts/index.html#hdrDyno

What you need is the information on creating dynamic named ranges, which
will expand or contract according to the size of your data. It looks a
little daunting at first, but you'll quickly get used to it. Then use the
range names in your calculations.

"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