WPS Office

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.

Free Download

Windows • MacOS • Linux • iOS • Android


A quick way to calculate sum, average, count, max, and min

Uploaded time: August 26, 2021 Difficulty Beginner

A quick way to calculate sum, average, count, max, and min

A quick way to calculate sum, average, count, max, and min

Here we have received a sheet on the Masks Sales in Single-Day Sheet from a supermarket. How can we quickly calculate the sum, average, maximum, and daily sales volume during the period from August 19th to 31st?

We can use the AutoSum feature of the WPS Spreadsheet, rather than calculating all data one by one with a calculator, which would be a waste of time. Follow these step.

1. Select the data area, click the AutoSum drop-down button in the Formulas tab.

2. Find the Sum button and click to quickly get the sum value result.

The method is the similiar to findaverages.

1.Select the data area of the table that needs to be averaged.

2. Click the AutoSum drop-down buttonin theFormulas tab.

3. Click the Average button, then you can calculate the average daily sales volume of masks in August.

We can also quickly calculate the maximum sales volume and minimum sales volume of Wal-Mart during this time period.


In addition, we can quickly count the number of days that masks have been selling in the supermarket during this time period.

Click the AutoSum drop-down buttonin the Formulas tab, and then the Count button. 4.gif

That's howAutoSum function in WPS Spreadsheet operates. For all, easy our work with WPS Spreadsheet like Microsoft Excel. Did you get it?

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