- Picture and text skills
- Case
Multiply the values in a specific field of records in the database that meet the specified criteria.
Syntax
DPRODUCT(database,field,criteria)
■Database A range of cells that constitutes a list or database. A database is a list containing a set of related data, which contains behavioral records of related information.
The columns containing 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, with quotes on both ends
Flag items, 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
Two columns, etc.
■Criteria is a group containing given conditions cell range. Any range can be specified for the criteria parameter, as long as it contains at least one column flag and column
The cell below the flag for setting conditions.
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/DPRODUCT-han-shu-ji-suan-li-run-cheng-ji.html
评论列表(196条)
测试