Countif on Range
That suggests that the cells in X are text values not true numbers.
--
__________________________________
HTH
Bob
"gtslabs" wrote in message
...
On Nov 27, 1:32 pm, "T. Valko" wrote:
Countif(X,"<="&K25)
There's nothing wrong with your formula.
Try this one and see what you get:
=SUMPRODUCT(--(X<=K25))
--
Biff
Microsoft Excel MVP
"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?- Hide quoted text -
- Show quoted text -
That returns the correct value of 2.
What could be happening?
|