This documentation is archived and is not being maintained.

XlConsolidationFunction Enumeration 

Specifies the subtotal function.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll)

'Usage
Dim xlConsolidationFunction1 As XlConsolidationFunction = XlConsolidationFunction.xlAverage

public enum XlConsolidationFunction
public enum XlConsolidationFunction
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.
xlUnknownNo subtotal function specified.
xlVarVariation, based on a sample.
xlVarPVariation, based on the whole population.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms

Show: