Excel statistics settings: How to count the number of specified values ​​in a column in Excel

Excel is a table document editing program. We can use the settings in the program to solve various problems encountered during the editing process of table documents. Today, a friend asked Excel how to count the number of specified values. In fact, it can be easily accomplished by using the COUNTIFS function. Next, the editor will talk about statistical methods. Operation method 1. Right-click a table document that needs to be edited on the computer, and then select the Excel option to open it.

2. After entering the Excel page, click on the cell below the column where the number of data needs to be counted, and then click on the toolbar to open the formula tool.

3. Open the insert function option, then find the COUNTIFS function in the pop-up box, click on the function and click OK.

1. After entering the function parameters page, set the data area in the Criteria range1 box, that is, click on the data box, and then select the area where the data is located in the table.

2. Then set the specified value in the Criteria1 box, and then click on the cell where the specified data is located in the table.
3. Finally click Confirm option.

   

   5. After clicking the OK option, we can specify the number of values ​​in the column in the cell.

   

The above is the detailed content of Excel statistics settings: How to count the number of specified values ​​in a column in Excel. For more information, please follow other related articles on the PHP Chinese website!