How to calculate average in wps2019

How does WPS2019 calculate the average? Want to calculate the average of multiple data or cells but can't find a way? PHP editor Zimo will introduce in detail the specific steps for calculating the average value in WPS2019, so that you can easily solve the problem.

Use wps2019 to open the table to be edited and calculate the average score of each class separately.

At this time, you only need to select all the data in column I in the table.

Click the [Merge and Center] icon on the toolbar.

The window for canceling the merge method of wps2019 will pop up next. Click the [OK] button.

You can see that the original merged cells in column I of the class have been automatically cancelled.

Enter =AVERAGEIFS(H2:H10,I2:I10,I2)

In the average score cell, you can see The average score has been automatically calculated.

Use quick fill to calculate the average score of the cells below.

The above is the detailed content of How to calculate average in wps2019. For more information, please follow other related articles on the PHP Chinese website!