XlConsolidationFunction enumeration
Office 2013 and later
Specifies the subtotal function.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
| 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. | |
| xlDistinctCount | Count using Distinct Count analysis. |
Show: