- Picture and text skills
- Case
Calculate the number of cells in the database that contain the specified condition number.
Syntax
DCOUNT(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 item in the first row.
Field can be text, that is, a label with quotes on both endsIndicator items, such as "age" or "yield";In addition, Field can also represent the position of the data column in the list
The number: 1 for the first column, 2 for the second column, etc.
Criteria is a set of cell ranges that contain given criteria. Any range can be specified for the criteria parameter, as long as it contains at least one column flag and column label
The cell below the log 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/DCOUNT-han-shu-tong-ji-fu-he-tiao-jian-de-shu-ju-ge-shu.html
评论列表(196条)
测试