All.
I have a table using the CountIf function in Sheet1 to capture data from Sheet2.
The table is setup as:
Fails By Age
<8 (col.K) 8-15 (col.L) 16-30 (col.M) >30 (col.N)
The CountIf function works for cols. L & M but not for K & N.
Is this because the criteria contains the "<" & ">" characters ?
I have also checked to see that the format matches.
Is there a way around this ?
Please advise.
Thanx.
I have a table using the CountIf function in Sheet1 to capture data from Sheet2.
The table is setup as:
Fails By Age
<8 (col.K) 8-15 (col.L) 16-30 (col.M) >30 (col.N)
The CountIf function works for cols. L & M but not for K & N.
Is this because the criteria contains the "<" & ">" characters ?
I have also checked to see that the format matches.
Is there a way around this ?
Please advise.
Thanx.