Advanced Excel Functions 简明教程

Advanced Excel - Database Functions

Excel Database 函数使用 Excel Database。这通常采用大型数据表的形式，其中表中的每一行都存储一个单独的记录。工作表表中的每一列都存储每条记录的不同字段。

The Excel Database functions work with an Excel Database. This typically takes the form of a large table of Data, where each row in the table stores an individual record. Each column in the Worksheet table stores a different field for each record.

Database 函数执行基本操作，例如求和、平均数、计数等，此外还使用条件参数，让你仅针对 Database 中记录的指定子集执行计算。Database 中的其他记录将被忽略。

The Database functions perform basic operations, such as Sum, Average, Count, etc., and additionally use criteria arguments, that allow you to perform the calculation only for a specified subset of the records in your Database. Other records in the Database are ignored.

Database Functions

下表列出了所有 Database 函数−

The following table lists all the Database functions −

S.No.

Function and Description

1

DAVERAGEAverages the values in a column of a list or database that match conditions you specify.

2

DCOUNTCounts the cells that contain numbers in a column of a list or database that match conditions you specify.

3

DCOUNTACounts the nonblank cells in a column of a list or database that match conditions you specify.

4

DGETReturns a single value from a column of a list or database that matches conditions you specify.

5

DMAXReturns the largest number in a column of a list or database that matches conditions you specify.

6

DMINReturns the smallest number in a column of a list or database that matches conditions you specify.

7

DPRODUCTMultiplies the values in a column of a list or database that match conditions you specify.

8

DSTDEVEstimates the standard deviation of a population based on a sample by using the numbers in a column of a list or database that match conditions you specify.

9

DSTDEVPCalculates the standard deviation of a population based on the entire population, using the numbers in a column of a list or database that match conditions you specify.

10

DSUMAdds the numbers in a column of a list or database that match conditions you specify.

11

DVAREstimates the variance of a population based on a sample by using the numbers in a column of a list or database that match conditions you specify.

12

DVARPCalculates the variance of a population based on the entire population by using the numbers in a column of a list or database that match conditions you specify.