It's my fault I'm not explaining this very well so I'll try a couple of ways.
I need a running total every time the random number in A1<.1. I need it to add 1 each time the random number is less than .1. The reset to 0 is what I'm trying to avoid. I'm looking for a way to have A2 add to itself each time the condition is met.
example
A1 .06, A2 1
recalculate A1 .4, A2 1
recalculate A1 .09, A2 2
|