How to use IF statement to add 1 to total? [Closed]

My question is slightly different: RANDOM calculation is created in cell J20 by pressing F9 (prompting different random values in J20). I want cell J21 to count the number of times J20>100.

I tried COUNTIF and IF but it didn't work, possibly because the search is done in an already populated range of cells.


Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!