1. Taking the excel2010 version as an example, first open the excel table and enter data in column A;

2. Now you want to count the number of times the number 5 appears in the data in column A, then first Enter the countif function in cell B1;

3. In the countif function, first enter the cell range that needs to be calculated to meet the conditions, namely A1 to A20, then enter the number 5 to be calculated, and press the enter key;

4. You will get the complete countif function formula, and also calculate that the number of occurrences of 5 is 3, and the calculation is correct;

5. In the same way, if you want to find other numbers, for example 10, then enter the number 10 into the second parameter of the countif function, and you can calculate the number of times the number 10 appears.