Excel basic formulas

excel basic formula:

1. Conditional summation formula

Let’s find the sum of the amounts of all waiters

We enter the formula in the conditional sum: =SUMPRODUCT((C2:C11="Waiter")*(D2:D11))

Return In this way, we can calculate the total amount of all waiters. The specific operation is shown in the figure below:

2. Sort the data

The test results are out, and the teacher wants to rank these results. How should we do it? What to do?

Method:

1. We can easily solve it with only one function formula. We enter the formula below the ranking: =RANK(A2,$A$2:$A$28)

2. Then select cell B2, place the mouse in the lower right corner, and when the mouse turns into a small cross, press Hold down the left mouse button and pull down to cell B28, so that the ranking of all scores will be displayed. The specific operation is shown in the figure below:

3. Calculate the data combination

After the teacher enters the scores of each student in each subject, The scores of each subject will definitely be combined into one. So, in Excel, is there any way to quickly enter the sum of students' scores in each subject?

Method:

Enter the function formula: =SUM(B2:F2), as shown in the figure below:

4. Calculate the average Chinese scores of boys and girls in the table

The teacher wants to see the average Chinese scores of boys and girls in the class. What should he do?

Method:

Input Excel function: =AVERAGEIF(B2:B28,"Male",C2:C28)

More For Excel related technical articles, please visit the Excel Basic Tutorial column to learn!

The above is the detailed content of Excel basic formulas. For more information, please follow other related articles on the PHP Chinese website!