I am having trouble with countif Function as described below.

Sorry MrExcleHTML is not working.

In the below cells, the following formulas and results are applied as below:

C67 =COUNTIF(K67:AA67,"<=5") results are 6 Should be 0

E67 =COUNTIF(K67:AA67,">=5.1") results are 11 Should be 1

G67 =COUNTIF(K67:AA67,">=8.1") results are 10 Should be 8

Entered Data

All Times are formatted as Custom hh:mm

All Numbers are formatted as Number 1 Decimal Place

J67 5:29 AM

K67 10.4

L67 7:06 AM

M67 12.6

N67 8:45 AM

O67 18.9

P67 9:45 AM

Q67 23.3

R67 12:31 PM

S67 7.9

T67 13:31

U67 9.8

V67 14:24

W67 12.9

C67 15:24

Y67 12.8

Z67 22:32

AA67 12.2

Do not want to move Times above Numbers entered.

Any help would be greatly appreciated.

Paul