Hi,

Why are there only 3 numbers <4 in that list? I count 14 with this formula

=COUNTIF((INDIRECT("a1:a" & MATCH(9.99999999999999E+307,A:A))),"<4")

Mike

"Antonio" wrote:

Hi all

Looking for a formula that count's, from last cell (undifined) upwards how
many cell < from 4, which from the list below should return 3

3
5
4
5
3
4
4
2
4
3
4
4
3
5
6
4
4
3
3
4
2
3
2

tks in advance
António