Biff,
I can confirm your observation for Excel 2002. It is apparently looking at
the "used range" for column A, and not resetting it when the data is deleted.
It will reset the formula (if you select the cell, click in the formula bar,
then hit Enter) when the file is saved or when you execute a VBA command to
count the rows in the used range ActiveSheet.UsedRange.Rows.Count
--
Brad


"Biff" wrote:

Hmmmm.....

I'm using 2002.

Try this...

Clear cells A2, A4 and A6

=COUNTIF(A:A,"<dog") then returns 6.

Clear the formula from B1 then type it in again. The formula still returns
6.

Biff

"byundt" wrote in message
...
1) Open a new workbook.
2) In cells A2, A4 and A6 enter the word "dog".
3) In cell B1 enter the formula:
=COUNTIF(A:A,"<dog")

In Excel 2003, I get 65533.
In Excel 97, 2000 and 2002, I get 3 (for the three blank cells between A1
and A6)

Thinking that it might be a corrupted Excel 2003 install, I asked a friend
to check his results--and he confirmed my experience. I'm using version
11.6355.6408 SP1.