Edit

Share via


XlConsolidationFunction Enum

Definition

Specifies the subtotal function.

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

Fields

Name Value Description
xlVarP -4165

Variation, based on the whole population.

xlVar -4164

Variation, based on a sample.

xlSum -4157

Sum.

xlStDevP -4156

Standard deviation, based on the whole population.

xlStDev -4155

Standard deviation, based on a sample.

xlProduct -4149

Multiply.

xlMin -4139

Minimum.

xlMax -4136

Maximum.

xlCountNums -4113

Count numerical values only.

xlCount -4112

Count.

xlAverage -4106

Average.

xlDistinctCount 11

Count using Distinct Count analysis.

xlUnknown 1000

No subtotal function specified.

Applies to