How to properly use the function COUNTIF

I am trying to use the function COUNTIF, to see how many numbers in a block are bigger or equal to 10. Since the block has a few cells only, I can count that there are 6. However, I wrote the function =COUNTIF(L7:L14; ">=10") and it shows that there are only 3, which I assume is the number os cells with numbers bigger that 10 (does not include equals to 10).
Can someone help please?

t90519.ods (13.6 KB)
works for me

I figured what the problem was. The cells contained the numbers 9,66666, for example, but were formatted to aproximate to the unit.
This is a project for school so I fixed it by changing the 10 in the formula to 9,5, I don’t know if there is other way or even if I can do that xd.

Avoid any formatting that lies about content. If the cell in question (9.666) has a formula, use =ROUND(whatever). Then the displayed value reflects the actual value.

1 Like