Hi,
What you can do is, type <11 in a cell (say A12) and then use a formula
=countif(range,A12)
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"gtslabs" wrote in message
...
I have a range of data called "X"
I am trying to count the number of values below a cell value say K25
(value in cell is 11)
I am using Countif(X,"<="&K25) and it returns 0 which is wrong.
If I use Countif(X,"<=11") it works.
What am I doing wrong?