Free All-in-One Office Suite with PDF Editor
Edit Word, Excel, and PPT for FREE.
Read, edit, and convert PDFs with the powerful PDF toolkit.
Microsoft-like interface, easy to use.
Windows • MacOS • Linux • iOS • Android
Use COUNT function to count the number of cells with parameters
Uploaded time: August 30, 2021 Difficulty Intermediate
Use COUNT function to count the number of cells with parameters
Use COUNT function to count the number of cells with parameters
When we do data statistics, we can use the COUNT function to count the number of cells containing values.
Take this table as an example. We need to count the number of cities participating in donations.Click cell E6 and click Insert Function to find the COUNT function. Click the OK button, now a dialog box will pop up.
Value 1 and Value 2 refer to the cell range to be statistically calculated.Only the numeric parameters are counted in this part of the range, that is to say, the number of cells with numerical values. Blank cells will not be counted.
Click Value 1and select the data in the Amount column. We can quickly get the number of cells with a donation amount of 57, which means that the number of cities participating in the donation is 57.
In addition, if we want to count text cells or cells containing other types of information, we can also use the COUNTA function. If we want to count the cells that meet a certain criterion, we can use the COUNTIF function or the COUNTIFS function.For furtherinformation on these functions, you are welcome to join our WPS Academy to learn more.
Also Read:
- 1. Use the ROW function to mark the row number
- 2. Use the text function to extract characters in cells
- 3. How to use the formula function of table in WPS Writer
- 4. How to apply accounting number format in WPS Spreadsheet
- 5. How to enter a number starting with 0 in the Spreadsheet
- 6. COUNTIFS function: count data of multiple criteria
Does this video help you?