SUBTOTAL function - Microsoft Support
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.
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
WORKDAY 函数 - Microsoft 支持
返回在某日期（起始日期）之前或之后、与该日期相隔指定工作日的某一日期的日期值。. 工作日不包括周末和专门指定的假日。. 在计算发票到期日、预期交货时间或工作天数时，可以使用函数 WORKDAY 来扣除周末或假日。. 提示: 若要通过使用参数来指示哪些天 ...
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, Excel 2013
IFERROR 函数 - Microsoft 支持
IFERROR 函数语法具有下列参数：. 价值 必需。. 检查是否存在错误的参数。. value_if_error 必需。. 公式计算结果为错误时要返回的值。. 评估以下错误类型：#N/A、#VALUE！. 、#REF！. 、#DIV/0！. 、#NUM！.
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, Excel Web App