Export (0) Print
Expand All
Expand Minimize

XlConsolidationFunction enumeration

Specifies the subtotal function.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

public enum XlConsolidationFunction

Member nameDescription
xlAverageAverage.
xlCountCount.
xlCountNumsCount numerical values only.
xlMaxMaximum.
xlMinMinimum.
xlProductMultiply.
xlStDevStandard deviation, based on a sample.
xlStDevPStandard deviation, based on the whole population.
xlSumSum.
xlVarVariation, based on a sample.
xlVarPVariation, based on the whole population.
xlUnknownNo subtotal function specified.
xlDistinctCountCount using Distinct Count analysis.
Show:
© 2015 Microsoft