If a range already contains subtotals, these are not used for further calculations. Use this function with the AutoFilters to take only the filtered records into account.
如果一个区域已包含分类汇总，则它们不能用于进一步的计算。将此函数和自动筛选同时使用，可以仅计算已筛选的记录。