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.