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.