1, sum function: sum function is the most common function summation formula, and it is also very simple to operate.

2. Sum with sumifs function. Since sumifs is a common function, you can directly search in the common function, and of course, you can also enter "sumifs" in "Search Function".

3. Conditional summation: the formula is = SUMPRODUCT ((F2 = B2: B8) * C2: C8 * D2: D8).

4.RANK function: Returns the ranking of one value in a list of values relative to other values. The format used is rank (number, reference, order).

Excel summary matters needing attention

1. You can't edit the PivotTable. If you want to edit the data, you need to copy and paste the data into a new worksheet, and change all the values to digital format before editing.

2, Number represents the numerical value to be sorted; Ref represents the cell area where the sort value is located; Order indicates the sorting method parameter (if it is "0" or omitted, it will be sorted in descending order, that is, the larger the value, the smaller the sorting result value; If it is a non-"0" value, it will be sorted in ascending order, that is, the greater the value, the greater the sorting result value.