How to sum the data in two tables in Excel

How to sum the data of two corresponding tables in Excel: determine the corresponding condition column (for example, column A of table A and column C of table B) and enter the formula in the result cell: =SUMIF(corresponding column, corresponding condition, Summing column) For example: =SUMIF(B!C, A!A, B!D) will find the sum of the values ​​in column D of table B that match the corresponding data rows in column A of table A.

Excel How to sum the data corresponding to two tables

The sum of data corresponding to the two tables is Excel Commonly encountered operations. The following steps illustrate how to use the SUMIF function to achieve this purpose:

Step 1: Determine the corresponding conditions

Determine the columns in the two tables that require corresponding data. For example, column A in table A contains names, and column C in table B also contains names.

Step 2: Create the SUMIF function

In the cell where the summation result needs to be placed, enter the following formula:

<code>=SUMIF(对应列, 对应条件, 求和列)</code>

Steps 3: Specify the corresponding columns and conditions

• Corresponding columns: Specify the columns that contain the corresponding data, such as B!C.
• Corresponding conditions: Specify the range of corresponding conditions, such as A!A.
• Sum column: Specify the column containing the data to be summed, such as B!D.

Example formula:

<code>=SUMIF(B!C, A!A, B!D)</code>

Description:

• This formula will check the column in table A values ​​in A and compare them to the values ​​in column C of table B.
• If the data for corresponding rows in the two tables match, the values ​​for the corresponding rows in column D in table B are summed.
• Then the summation result is displayed in the specified result cell.

Note:

• The corresponding condition and summation column must be in the same row.
• The corresponding condition can be text, number or logical value.
• If no matching corresponding condition is found, the SUMIF function will return 0.

The above is the detailed content of How to sum the data in two tables in Excel. For more information, please follow other related articles on the PHP Chinese website!