The SUBTOTAL function can control whether or not hidden rows are included in the results and always ignores rows that have been filtered.

• SUBTOTAL函数可以控制是否在结果中包括隐藏的行,并始终忽略已过滤的行。