What's wrong with this COUNTIF formula?

Giganews Newsgroups
Subject: What's wrong with this COUNTIF formula?
Posted by:  Dave Potter (dpotter41 at chartertn NOSPAM dot net)
Date: Wed, 08 Oct 2003

=COUNTIF(weekly355comp2000,">A105")

A105=20000
There are a number of cells in the range greater than 20000 but the
formula returns 0.

thanks

Replies