Mike tks for your prompt reply.

need only to count the last (in this case 3) < from 4

is it possible to adapt the formula??

Tks in advance

"Mike H" wrote:

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