How do you count how often a specific value occurs in single changing cell? I thought =countif would work but everytime the cell changes it takes the count back to 0. I'm using random numbers and would like to count each time the number is below .1. 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 (Random numbers generate in cell A1)
A1=.06, A2=1
recalculate A1=.4, A2=1
recalculate A1=.09, A2=2


Posted here first but was recommended to come here for VBA help.
https://www.msofficeforums.com/excel...html#post69714