Current location - Quotes Website - Signature design - How to sum a person's value in WPS form?
How to sum a person's value in WPS form?
In WPS table, you can use SUMIF function to count the value of a signer in the big table on the left. The following steps are how to use the SUMIF function to sum:

First, in the small table on the right, select the cell that needs and.

Then click Formula in the menu bar and select Insert Function from the drop-down menu.

In the Insert Function dialog box, select the SUMIF function and click OK.

In the parameter setting of SUMIF function, three parameters need to be set:

Range: the range of cells for conditional judgment. Here, you should select the column of celebrity signature in the big table on the left.

Standard: indicates conditions. Here, you should enter the name of the signer you want to count.

Sum_range: the range of cells to sum. Here, you should select the value column in the large table on the left.

After setting the parameters, click OK, and the cells in the small table on the right will display the statistical results.

Note: When using the SUMIF function, the signer column and the numerical column must be on the same line, otherwise the statistical results may be inaccurate. If the name column and the value column in the table are not in the same row, you need to adjust the data properly before using the SUMIF function.