XlConsolidationFunction Enumeration
Specifies the subtotal function.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Public Enumeration XlConsolidationFunction
'Usage
Dim instance As XlConsolidationFunction
public enum XlConsolidationFunction
Members
| Member name | Description | |
|---|---|---|
| xlAverage | Average. | |
| xlCount | Count. | |
| xlCountNums | Count numerical values only. | |
| xlMax | Maximum. | |
| xlMin | Minimum. | |
| xlProduct | Multiply. | |
| xlStDev | Standard deviation, based on a sample. | |
| xlStDevP | Standard deviation, based on the whole population. | |
| xlSum | Sum. | |
| xlVar | Variation, based on a sample. | |
| xlVarP | Variation, based on the whole population. | |
| xlUnknown | No subtotal function specified. |