XlConsolidationFunction Enumeration

Excel Developer Reference

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.