adjusting formula, after data order reversed

here's a file, you're right i need it to check bottom to top the most recent negative streak heading up to 0...the answer should also be 344 like the other 2..........

This formula is basically calculating days in current drawdown, If the most recent cell is 0, then answer is 0, if most recent cell(bottom most) is negative then count upwards the number of cells till u get a 0(but dont count the 0)

thanks

thanks NBVC

but it doesnt work
getting error mesg, says ive entered too few arguments for function

this is how i changed it in my worksheet and it doesnt work

=COUNTIF(INDEX(Drawdown1,MATCH(2,1/Drawdown1=0))):INDEX(Fund1!$G:$G,lrow,"<0")


It doesnt recognize anything after the third bracket right next to 1/Drawdown1=0)))

i dont understand why, it works in the file i attached

Drawdown figures are in Column G in my version

thanks buddy, it works great now!!

wow, helped from good ole mississauga, i went to UTM!