bill gras wrote:
Hi Aladin
No . What I'm saying is that number 3 should be the only number (where it is)
and no number 2 because 107 is greater than 35 and that should be the cut off
point , there fore the next sequence should start after the #value! in
column AU45 . So the next sequence starts at AU 46 where the first number is
greater than 35 and that is the cut off point (no result) . The next sequence
starts at AU 51 after the #value! in AU50 and number 2 is correct , the cut
off point is at AU53 which the number is 146 so no number 3 . The next
sequence starts at AU58 after the #value! of AU57.

I hope this will help , please don't give up
thanks bill

A38:AV57 looks like this, produced with:

=IF(OR(ISERROR(AU39),SUMIF(AU39,"35")35),
"",
IF(IF(ISERROR(AU40),1,AU4035),
COUNTIF(INDEX($AU$39:AU39,
MATCH(9.99999999999999E+307,$AV$38:AV38)):AU39,"<= 35"),
""))

0
32
14
19 3
107
11
21 2
#VALUE!
40
45
16
15 2
#VALUE!
29
11 2
146
14
17
11 3
#VALUE!

What the formula does is to count all values < 35 between the last count
and just before a value 35 or before a #VALUE!. If you want to,
reproduce the desired counts using the quoted section.