XlConsolidationFunction Enum

Definition

Namespace:

Microsoft.Office.Interop.Excel

Assembly:

Microsoft.Office.Interop.Excel.dll

Specifies the subtotal function.

public enum class XlConsolidationFunction

public enum XlConsolidationFunction

Public Enum XlConsolidationFunction

Inheritance

Enum

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.