Bill,

The formula will return an incorrect result when a sequence does not
contain a number greater than 35. Therefore, try the following formula
instead...

=IF(ISERR(AU38),COUNTIF(AU39:INDEX(AU39:$AU$500,MA TCH(TRUE,IF(ISNUMBER(AU
39:$AU$500),AU39:$AU$50035,ISERR(AU39:$AU$500)),0 )),"<=35"),"")

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

In article ,
bill gras wrote:

Hi Domenic
Thanks for your reply and your time , your fomula works perfect
Once again thanks
regards bill

--
bill gras