This documentation is archived and is not being maintained.

XlConsolidationFunction Enumeration

Office 2007
Specifies the subtotal function.

Version Information
 Version Added:  Excel 2007

NameValueDescription
xlAverage-4106Average.
xlCount-4112Count.
xlCountNums-4113Count numerical values only.
xlMax-4136Maximum.
xlMin-4139Minimum.
xlProduct-4149Multiply.
xlStDev-4155Standard deviation, based on a sample.
xlStDevP-4156Standard deviation, based on the whole population.
xlSum-4157Sum.
xlUnknown1000No subtotal function specified.
xlVar-4164Variation, based on a sample.
xlVarP-4165Variation, based on the whole population.


Show: