This documentation is archived and is not being maintained.

XlConsolidationFunction Enumeration

Specifies the subtotal function.

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.

Show: