SUBTOTAL function - Microsoft Support
The SUBTOTAL function is designed for columns of data, or vertical ranges. It is not designed for rows of data, or horizontal ranges. For example, when you subtotal a horizontal range using a function_num of 101 or greater, such as SUBTOTAL (109,B2:G2), hiding a column does not affect the subtotal.
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
SUMPRODUCT 函数 - Microsoft 支持
如何在 Excel 中使用 SUMPRODUCT 函数（Excel 的数学函数和三角函数之一），使用乘法、加法、减法和/或除法返回相应范围或数组的乘积之和。.
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