i understand that you try to simplify the example, but many factors can affect the results. like the change in column or if there's a formula in it. you can still do up a sample, but considering all these factors if possible. i do love reading a simplified eg. try these now:
=IF(INDEX($F$53:$S$53,COUNTIF($F$53:$S$53,"<>0"))>0,COUNTIF(F53:S53,"<>0")-MAX(IF($F53:$S53<0,COLUMN($F53:$S53)-5)),"")
=IF(INDEX($F$53:$S$53,COUNTIF($F$53:$S$53,"<>0"))<0,COUNTIF($F$53:$S$53,"<>0")-MAX(IF($F53:$S53>0,COLUMN($F53:$S53)-5)),"")
Bookmarks