I started a thread with a casual comment on COUNTIF and blank and zero. Then I did more tests which led Sandy to do hers and discover that according to COUNTIF

"" = Blank but Blank < ""

Roger confirmed the finding by doing a detailed and interesting test using various versions of Excel (starting from 97).

Kudos to both of them. Since we have spent quite a bit of time in this investigation, I want to share our "discovery" with all. So, I hereby invite everyone to take a look at the experiment.

If you don't want to go through the entire thread, you can just click on post #25 by Roger. Please feel free to comment, but please include it under the other thread. Here is the link:-

http://groups.google.ca/group/micros...coring=d&hl=en


or http://tinyurl.com/y6fowz

Roger, I appreciate your effort.

Epinn