Hello all,
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
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