- Graphic skills
- Cases
Sum the numbers in the field columns of the records in the database that meet the criteria.
Grammar
DSUM(database,field,criteria)
Database A range of cells that makes up a list or database.
A database is a list that contains a set of related data, behavioral records that contain related information, and the columns that contain the data are fields. The first row of the list contains the flags for each column.
Field specifies the data column used by the function. The data columns in the list must have a flag entry in the first row.
Field can be text, that is, a flag item with quotes on both ends, such as "tree age" or "yield"; in addition, Field can also be a number representing the position of the data column in the list: 1 represents the first column, 2 represents the second column, etc.
Criteria is a set of cell ranges that contain given criteria. You can specify any range for the criteria parameter, as long as it contains at least one column flag and a cell below the column flag for setting the criteria.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/zhang-wo-DSUM-han-shu-shi-xian-gao-xiao-tiao-jian-qiu-he-ji-qiao.html
支付宝扫一扫 
评论列表（196条）
测试