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

Efficient statistics with statistical functions

Uploaded time: September 30, 2021 Difficulty Intermediate

Efficient statistics with statistical functions

Efficient statistics with statistical functions

COUNT function and COUNTIF function are used very frequently in statistical functions. Today I'll talk about how to use these two functions.

· 1. COUNT function

Take this donation list as an example. We need to count the number of cities with donation amounts. At this point, we can use COUNT function.Click cell E6, enter =COUNT(C3-C75), and press the Enter key to get the result.

It is important to note that the COUNT function can only count the statistical cells. The forms like blank cells and text can not be counted. This case makes use of the COUNT function's inability to count blank cells and give the correct statistics for cells with donation amounts.

· 2. COUNTIF

If we want to count the number of cities with donation amounts greater than 50,000, we can use the COUNTIF function.

Click cell E10, enter =COUNTIF(C3-C75,>50000) and press the Enter key to get the result.

The function formula has two parameters: Range and Criteria.

Range is a statistical range, that is cell range C3-C75 in this table. Because we count the number of cities with donation amounts greater than 50,000, >50,000 is our criteria.

Remember to use double quotes when entering criteria.

To learn more about how to use the statistical functions, you're welcome to enter WPS Academy.

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