Edit

Share via


XlConsolidationFunction Enum

Definition

Specifies the subtotal function.

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

Fields

xlAverage -4106

Average.

xlCount -4112

Count.

xlCountNums -4113

Count numerical values only.

xlDistinctCount 11

Count using Distinct Count analysis.

xlMax -4136

Maximum.

xlMin -4139

Minimum.

xlProduct -4149

Multiply.

xlStDev -4155

Standard deviation, based on a sample.

xlStDevP -4156

Standard deviation, based on the whole population.

xlSum -4157

Sum.

xlUnknown 1000

No subtotal function specified.

xlVar -4164

Variation, based on a sample.

xlVarP -4165

Variation, based on the whole population.

Applies to