SUMIF function - Microsoft Support
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.
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
SUMIF function - Microsoft Support
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.
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
使用 SUM 函数对区域中的数字求和 - Microsoft 支持
使用 SUM 函数对区域中的数字求和. Microsoft 365 专属 Excel Excel 网页版 更多... 可以使用 简单的公式对) 一组单元格 (区域中的数字求和，但在处理多个数字时 ，SUM 函数 更易于使用。. 例如，=SUM (A2：A6) 出现键入错误的可能性小于 =A2+A3+A4+A5+A6。. 下面是使用两个单元 ...
Applies To:
Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
SUMPRODUCT 函數 - Microsoft 支援服務
SUMPRODUCT 函數會傳回對應範圍或數位之產品的加總。. 默認運算為乘法，但加法、減法及除法也有可能。. 在此範例中，我們將使用 SUMPRODUCT 傳回指定專案和大小的總銷售額：. SUMPRODUCT 會比對專案 Y/Size M 的所有實例並加總，因此此範例 21 加 41 等於 62。.
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
SUM 函數 - Microsoft 支援服務
如何在 Excel 中使用 SUM 函數來新增個別值、單元格參照、範圍，或混合使用這三個值。.
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016