Countifs giving me strange results

[JeffGrant]

Hi All,

In the attached spreadsheet, I have:

Col A - a series of numerical values
Col B - a mixture of numeric & string values

Cell D3 has the formula = COUNTIF(A2:A25,"<=23") -> which gives a result of 7 which is correct
Cell E3 has the formula = COUNTIF(B2:B25,"x") -> which gives a result of 3 which is correct
Cell F4 has the formula = COUNTIFS(A2:A25,"<=23",B2:B25,"x") -> which gives a result of 2 which is correct

However, if I change the fixed criteria to cell reference criteria, it all falls apart.

So, if I put the value of 23 in cell D6 then, when "<=23" is replaced with "<=D6" -> I get a result of 16.

Can anybody please give me an idea / correction to what I am doing wrong?

Thanks in advance.

[josephteh]

Try =COUNTIF(A2:A25,"<="&D6)

[JeffGrant]

Well that makes a lot more sence.

Cant believe Imissed the obvious.

Thanks.