一、SUBTOTAL函数基础知识 SUBTOTAL函数表示在指定的范围内根据指定的分类汇总函数进行计算 语法结构：=SUBTOTAL（功能参数，数据） 二、SUBTOTAL函数的应用 1、添加序号 ...

For many years, I used the SUBTOTAL function in Microsoft Excel to create easily visible subtotals at the top of my worksheets. However, when I encountered AGGREGATE, this became my go-to function for ...