Hi Aladin,
Thank you for your time and your reply
There is one thing that your formula does not do is: count all numbers under
35 , stop at the first number larger than 35 and than go to the next sequence
, and count
all numbers under 35 stop at the first number larger than 35 and than go to
the next
sequence , and so on .
Can that be done ?
I apologise if I did not explained my self properly the first time .
as per your formula :-
-- AU
row 39 32
40 14
41 19 3
42 107
43 11
44 21 2
45 #value!
46 40
47 45
48 16
49 15 2
50 #value!
51 29
52 11 2
53 146
54 14
55 17
56 11 3
57 #value!
I hope you can still help me as I'm nearly finished my project
Thanking You
regards bill
bill gras


"Aladin Akyurek" wrote:

Replace "result" with 0 in AV38 and enter in AV39 & copy down:

=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"),
""))

bill gras wrote:
I have in column AU cell 39 to cell 500 random sequences of 1-10 rows ,
with numbers in them, (as an result of formulas)
I need to count the number of rows in each sequence that have numbers
of 35 or less , but only up to the first number of 35 or higher. eg:-

AU result
row 39 32 3
40 14
41 19
42 107
43 11
44 21
45 #value!
46 40
47 45
48 16
49 15
50 #value!
51 29 2
52 11
53 146
54 14
55 17
56 11
57 #value!
and so on down to 500 rows

all help is appreciated

thanks
bill gras