XlConsolidationFunction Enumeration
Specifies the subtotal function.
Version Information
Version Added: Excel 2007
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. |