摘要
在Excel中进行数据处理时,数据汇总是最频繁的操作之一。通过SUM函数对数据进行无条件汇总是易于理解的方法,但仅仅只是掌握一个SUM函数,在进行数据汇总时还远远不够。本文介绍其他几个函数用来进行满足一定条件的数据汇总方式,包括SUMIF函数、SUM函数与IF函数组合应用、SUMPRODUCT函数和DSUM函数。灵活应用函数进行数据汇总是实现办公自动化的一项基本技能。
Data processing in Excel,data summary is one of the most frequent operation. By means of SUM function tounconditional summary data is an easy method to understand,but only to master a SUM function to summary data is notenough. In this paper,several other functions used to meet certain conditions way collection of data,including SUMIFfunction,the composite application of the SUM function and the IF function,SUMPRODUCT function and DSUM function.Flexible application function for data summary is a basic skill to realize office automation.
出处
《办公自动化》
2014年第24期48-50,共3页
Office Informatization