WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android

banner

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.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.