What are the WPS summation formulas?

wps summation formulas are: 1. Area summation "=SUM (condition area)"; 2. Mixed summation "=SUM (condition 1, condition 2...)"; 3. Intersection area Sum “=SUM(condition 1 condition 2)”; 4. Single condition sum “=SUM((condition 1=array 1)*(condition 2))”; 5. Multi-condition sum “=SUM((condition 1=array1)*(condition2=array2)); 6. Nested FILTER function summary sum "=SUM(FILTER(condition1, condition2=array1))".

The operating environment of this tutorial: Windows 10 system, WPS 2009 version, dell g3 computer.

The SUM function is the most commonly used and basic summation function in WPS tables. Format: Usage of the SUM function: SUM (array 1,...) or SUM ((condition area 1 = condition 1) * (condition area 2 = condition 2) *... * summation area); the SUM function returns a certain area The sum of all values ​​in the cell. It can sum the values ​​of cells in continuous or discontinuous areas, and can also sum multiple conditions. The SUM function is a summation function often used in WPS tables.

The specific usage of the SUM function is as follows:

(1) Sum the horizontal continuous areas, as shown in the table below. The area from data 1 to data 4, that is, column C to column F, must be calculated in rows. To perform the sum, in the summing result placement area, enter the formula in cell G3: =SUM(C3:F3). The formula represents the result of adding the values ​​of the four cells C3, D3, E3, and F3.

Sum vertically continuous areas. As shown in the table below, the data 1 to data 4 area, that is, column C to column F, must be summed column by column. In the summation result placement area, unit F18 Enter the formula: =SUM(F2:F17). The formula represents the result of adding the values ​​in the vertical cells in rows F2 to F17.

(2) Mixed sum .As shown in the table below, you need to sum the values ​​of the three cells or areas C2, D4:E5, and F8:F11 in the data table. In the area where the summation result is placed, enter the formula in cell I2: =SUM(C2,D4: E5,F8:F11), the formula represents the result of adding the values ​​in the C2, D4:E5, F8:F11 cells and range.

(3) Intersection Area summation. As shown in the table below, the values ​​at the intersection of the C2:E11 area and the D6:G13 area in the data table need to be summed, that is, the values ​​in the blue area are summed. In the area where the summation result is placed, unit I2 Enter the formula: =SUM(C2:E11 D6:G13)). In the formula, the C2:E11 area and the D6:G13 area are separated by spaces. The summation result will be the value of the intersection of the two areas. And.

(4) Single condition sum. As shown in the table below, the data of each county in the data table needs to be summed, that is, the data column 1 is summed. In the summing result placement area, enter the formula in unit J2: =SUM(($A$2:$A$17=I2)*($C$2:$C$17)). In the formula, $A$2:$A$17=I2 is Sum the data in the A2:A17 area that matches I2 and correspond to C2:C17, that is, sum the data in the A2:A17 area that matches the data in Lingyun County.

(5) Multi-condition summation. As shown in the table below, the data of each county in the data table needs to be summed, that is, the data column 1 is summed. In the summing result placement area, enter the formula in unit K2: =SUM(($A$2:$A$17=I2)*($B$2:$B$17=J2)*$C$2:$C$17), in the formula $A$2:$A$17=I2 is the sum of the data in the A2:A17 area that matches I2 and $B$2:$B$17=J2 is the sum of the data in the B2:B17 area that matches J2 and corresponds to C2:C17. That is, the data in the A2:A17 and B2:B17 areas are consistent with the data in Sicheng Town, Lingyun County.

(6) SUM nested FILTER function summary summation. As shown in the table below, the data of each county in the data table must be summarized and summed, that is, the data from column 1 to column 4 must be summarized and summed for all data in a certain county. In the summing result placement area, enter the formula in cell I2: =SUM(FILTER($C$1:$F$17,$A$1:$A$17=H2)), in the formula FILTER($C$1:$F$17, $A$1:$A$17=H2) is to filter out all the data in column A that matches H2. The SUM function is to sum up all the data filtered out by the FILTER function.

The above is the detailed content of What are the WPS summation formulas?. For more information, please follow other related articles on the PHP Chinese website!