It seems simple but I can't figure it out and can't find it on google. 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.

Example


A1 +RAND()
A2 =Countif(A1<.1),1