How to calculate the sum of data that meets multiple conditions with one click in excel_Using process of DSUM function in excel

When processing massive data, how to quickly calculate the sum of data that meets multiple conditions? PHP editor Yuzai teaches you how to use the DSUM function in Excel, which can easily meet your needs. Please continue reading for the detailed process.

1. The product name and output information are recorded in the table. Now we are required to quickly calculate the total output of the products watermelon and grapes.

2. Here we use the DSUM function to implement it, enter =DSUM() in the cell.

3. The first parameter of the DSUM function is the data area. Here we can select the entire table area.

4. The second parameter of the DSUM function is [operation domain], which is which column in the database area we sum. Here we enter 2.

5. The third parameter of the DSUM function is the condition. Here we select the condition area. The condition area has given two conditions, watermelon and grape.

6. After completing the function, the total output of grapes and watermelons that meet the two conditions will be automatically displayed.

The above is the detailed content of How to calculate the sum of data that meets multiple conditions with one click in excel_Using process of DSUM function in excel. For more information, please follow other related articles on the PHP Chinese website!