I replaced COLUMN with the range of cells and I replaced X with my value, but
it didn't work. It returned a 0, when I know I have 9 cells that are less
than x.


bj wrote:
=countif(Column,"<x")

I want to count the number of cells in a column that have a value less than x.
Any tips?


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200507/1