:Clever use of DSUM function for quick conditional summation-Table skills免费ppt模版下载-道格办公

Clever use of DSUM function for quick conditional summation

Picture and text skills
Case

Sum the numbers in the field columns of the records in the database that meet the conditions.

Grammar

DSUM(database,field,criteria)

￭ Database A range of cells that make up a list or database.

A database is a list that contains a set of related data, which contains behavioral records of related information, andcontains data The columns are fields. The first line of the list contains

Flag items 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 "age" or "yield";

Alternatively, Field can be a number that represents the position of a data column in the list: 1 for the first column, 2 for the second column, and so on.

￭ Criteria is a set of cell ranges that contain given conditions.

You can specify any range for the criteria parameter, as long as it contains at least one column label and a cell below the column label 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/qiao-yong-DSUM-han-shu-kuai-su-tiao-jian-qiu-he.html