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

Report

hat - Updated on Dec 10, 2017 at 11:53 PM

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.

Thanks

How to use IF statement to add 1 to total?
Excel - Using IF statement to add 1 to total - How-To - Excel
Formula to add 1 with IF statement ✓ - Forum - Excel
Android adds 1 to phone numbers - How-To - Android
Excel if cell contains any text then add 1 ✓ - Forum - Excel
Jio Adds 1,000 Subscribers Per Minute - News

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

Your reply

Subscribe To Our Newsletter!