XlConsolidationFunction Enumeration
Specifies the subtotal function.
Version Information
Version Added: Excel
| Name | Value | Description |
|---|---|---|
| xlAverage | -4106 | Average. |
| xlCount | -4112 | Count. |
| xlCountNums | -4113 | Count numerical values only. |
| 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. |