Hi,

I had never expected the result that comes out from this example:
Excel cannot mix text and figures in 1 single list of values. Her
comes what happens:

My model contains, in A1 to A6 the values

1
2
3
a
b
c

In B1 I input COUNTIF($A$1:$A$6,"<="&$A$1:$A$6) and I copy it down to
B6. I get:

1
2
3
1
2
3

instead of

1
2
3
4
5
6

My question: why if 1 and 2 and 3 are smaller than "a", the count of
values smaller than or equal to "a" returns 1 and not 4. I cannot
understand it.

Does anybody have any suggestions?

Thank you