How to calculate the average of WPS, there are many WPS numbers that cannot be calculated as average

1. Open the WPS** software and enter the operation interface of WPS**.

2. Enter some data in this input area.

3. Select a cell as the result cell, and then find the formula option in the menu bar above.

4. Click on the formula option and find the auto-sum option in its own menu.

5. Click on the Auto-Sum option and find the average value in its drop-down menu.

Options. <>

6. Click on the average option, and you can see that there is an average calculation formula in the cell we just selected.

7. Click the Enter key on your keyboard.

The average is calculated.

Hello, take the WPS2019 version as an example.

Right-click the toolbar at the bottom and select Average.

If you're having trouble averaging a lot of numbers when using WPS, try the following:1Check Number Cell Formatting:

Enter the correct format of the number in the number cell, including the position of the decimal point and the number of digits. If the cells are not formatted correctly, it may lead to errors in the calculation. 2.

Check the range of number cells: When you use the Average beat function to calculate the average, you need to select all the number cells to be averaged. If the range of cells is incorrect, it may lead to an error in the average calculation.

3.Check other cell contents: If there are other blank or non-numeric cells or contents between the number cells, it may affect the average calculation.

The problem can be avoided by selecting the correct range of cells. 4.Try a different calculation method:

If the above methods do not solve the problem, you can try to use other calculation methods, such as using the "sum" function to calculate the sum of all number cells, and then divide by the number of number cells to get the average. 5.Restart WPS **:

Sometimes, WPS** may have some errors, and restarting the software and then doing the calculations may resolve the issue. If you are still unable to resolve the issue, we recommend that you consult WPS customer service for more detailed technical support.

WPS wants to calculate the average of the data in **.

How should the congratulatory hall calculate? Let's take a look at the detailed tutorial below.

Software name: 1. Start WPS software on your mobile phone.

And create a new blank worksheet, enter 20 in cell A1; Enter 30 in cell b1; Next, ask for an average.

Displayed in cell C1.

2. Click the C1 cell with your finger and click the button in the lower left corner of the page to open the operation panel.

4. Go to another page, click on the common function, and then open another page, in this page, we click on the function of the average.

5. Then, at this time, the input box pops up, the function has been displayed in the input box, we use our fingers to click A1 and B1 respectively, 6, at this time, A1 and B1 are automatically displayed in the input box, forming a function formula, then, we click the Tab key on the right side again.

7. Then, the C1 cell will be displayed. The result is 25, then, this operation is complete.

The above is the tutorial of WPS calculating the average value of data, I hope you like it, today I will share with you how to find the average score of a specific proportion of results in WPS**? If you are interested in this, let's learn it together, and the following is the specific content.

In WPS, we can use the sum function.

and array formulas solve this problem and get us rid of cumbersome operations.

Let's start by finding the number of students in the top 30% of the language subjects in Column C. Click on cell C96 and enter the following formula in the cell: "=sum(1*(rank(c$3:c$95,c$3:

c$95)<=50*, then position the mouse over the bar and press the "Ctrl+Shift+Enter" shortcut key.

You can see that the outer layer of the formula is automatically added to the marker of the array formula with a pair of curly braces.

The total score of eligible students is basically the same as the number of students. Just enter the following formula in cell c97 "=sum((c$3:c$95)*(rank(c$3:

C$95,C$3:C$95)<=C96))" Then remember to press the "Ctrl+Shift+Enter" shortcut to get the corresponding score.

As for that average score, it's even simpler. Just enter the formula "=C97 C96" into cell C98 and press Enter.

You can get the score you need.

Select the C96:C98 cell. Drag the fill handle of the cell range to the right to copy the formula to cell G98. When you release the mouse, you can easily get the number of eligible people, the total score, and the average score for all subjects, as shown in Figure 3.