Excel.AggregationFunction enum

数据透视字段的聚合函数。Aggregation Function for the Data Pivot Field.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

字段

automatic = "Automatic"

Excel 将根据数据项自动选择聚合。Excel will automatically select the aggregation based on the data items.

average = "Average"

使用平均数据 (相当于 average 函数) 进行聚合。Aggregate using the average of the data, equivalent to the AVERAGE function.

count = "Count"

使用数据中项的计数 (相当于 COUNTA 函数) 进行聚合。Aggregate using the count of items in the data, equivalent to the COUNTA function.

countNumbers = "CountNumbers"

使用数据中的数字计数进行聚合, 相当于 count 函数。Aggregate using the count of numbers in the data, equivalent to the COUNT function.

max = "Max"

使用数据的最大值 (相当于 MAX 函数) 进行聚合。Aggregate using the maximum value of the data, equivalent to the MAX function.

min = "Min"

使用数据的最小值 (相当于 MIN 函数) 进行聚合。Aggregate using the minimum value of the data, equivalent to the MIN function.

product = "Product"

使用数据的产品进行聚合, 相当于 product 函数。Aggregate using the product of the data, equivalent to the PRODUCT function.

standardDeviation = "StandardDeviation"

使用数据的标准偏差 (相当于 STDEV 函数) 进行聚合。Aggregate using the standard deviation of the data, equivalent to the STDEV function.

standardDeviationP = "StandardDeviationP"

使用数据的标准偏差 (相当于 STDEVP 函数) 进行聚合。Aggregate using the standard deviation of the data, equivalent to the STDEVP function.

sum = "Sum"

使用数据的总和 (相当于 sum 函数) 进行聚合。Aggregate using the sum of the data, equivalent to the SUM function.

unknown = "Unknown"

聚合函数未知或不受支持。Aggregation function is unknown or unsupported.

variance = "Variance"

使用数据的方差进行聚合, 相当于 VAR 函数。Aggregate using the variance of the data, equivalent to the VAR function.

varianceP = "VarianceP"

使用数据的方差进行聚合, 相当于 VARP 函数。Aggregate using the variance of the data, equivalent to the VARP function.