XlConsolidationFunction XlConsolidationFunction XlConsolidationFunction Enum

Definition

Specifies the subtotal function.

public enum class XlConsolidationFunction
public enum XlConsolidationFunction
Public Enum XlConsolidationFunction
Inheritance
XlConsolidationFunctionXlConsolidationFunctionXlConsolidationFunction

Fields

xlAverage xlAverage xlAverage -4106

Average.

xlCount xlCount xlCount -4112

Count.

xlCountNums xlCountNums xlCountNums -4113

Count numerical values only.

xlDistinctCount xlDistinctCount xlDistinctCount 11

Count using Distinct Count analysis.

xlMax xlMax xlMax -4136

Maximum.

xlMin xlMin xlMin -4139

Minimum.

xlProduct xlProduct xlProduct -4149

Multiply.

xlStDev xlStDev xlStDev -4155

Standard deviation, based on a sample.

xlStDevP xlStDevP xlStDevP -4156

Standard deviation, based on the whole population.

xlSum xlSum xlSum -4157

Sum.

xlUnknown xlUnknown xlUnknown 1000

No subtotal function specified.

xlVar xlVar xlVar -4164

Variation, based on a sample.

xlVarP xlVarP xlVarP -4165

Variation, based on the whole population.

Applies to