You use the SUMIF function to sum the values in a range that meet criteria that you specify. For example, suppose that in a column that contains numbers, you want to sum only the values that are larger than 5.

Returns a subtotal in a list or database. It is generally easier to create a list with subtotals by using the Subtotal command in the Outline group on the Data tab in the Excel desktop application. Once the subtotal list is created, you can modify it by editing the SUBTOTAL function.

如何在 Excel 中使用 SUMPRODUCT 函数（Excel 的数学函数和三角函数之一），使用乘法、加法、减法和/或除法返回相应范围或数组的乘积之和。.