Count if column has numerical value

Problem 1 COUNTA(T:T)

Problem 2 COUNTIF(T:T,"<0.8")

See the yellow cells in the attached file (for both questions).

for your second question; is it also possible you have a value of 0,7 in the cell, and that value has also be counted?

I'm not able to attache a file, so i will attache it later.

Oeldere's solution doesn't quite work. Type any value into sheet 2, T12 and the count of <0.8's incorrectly re-sets to zero. To be honest, I'm not sure how oedelere got it to work at all!!!

Excel has a quirk in the way that it handles these quasi-numerical strings. You need to use

=COUNTIF(Sheet3!T9:T200,"*<0.8")

instead.

@Glenn Kennedy

2nd question =countif(Sheet3!$T$9:$T$20,Sheet2!$AA$2)

I used a cellreference to get the result.

aa2= <0.8

see also my question on the topic (#4)

Please Login or Register  to view this content.

And what happens if you add another <0.8 in sheet 3 column T? Does you equation work OK?

Regarding your other Q. The <0.8 is a detection limit or a lower reporting limit, or similar. It will always be that value.

I don't have PC access so can't check it out myself