一、自动求和
二、自动计数
1.公式法:= countif (A1: A100, B1: B100)
2.函数法:= sumproduct (A1: A100, B1: B100)
3.模糊查找法:= MID (A1: A100, B1: B100)
4.文本法:= text (A1: A100, B1: B100)
5.名称法:= numeric (A1: A100, B1: B100)
6.列表法:= list (A1: A100, B1: B100)
7.模糊查询法:= SMALLUP (A1: A100, B1: B100)
8.模糊查找法:= SMALLUP (A1: A100, B1: B100)
9.模糊查询法:= SUM (A1: A100, B1: B100)
三、自动填充
四、自动排序
五、自动筛选
六、自动汇总
七、自动分类汇总