摘要
在实际工作中,经常会遇到需要将一些数据按规定的数据段进行统计。本文通过具体案例详细介绍了利用Excel函数实现分段统计的三种方法和使用注意事项,并对其进行了比较。
In practical work,we often need to statistics the data according to the stated data segment.Through some concrete examples,this article detailedly introduces the three ways and applying notices of subsection statistics by using Excel Function.And also,it makes a comparison of them.
关键词
分段统计
数组公式
函数
Subsection Statistics Array Formula Function