XlConsolidationFunction Enumeration
TOC
Collapse the table of content
Expand the table of content

XlConsolidationFunction Enumeration (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Specifies the subtotal function.

Name

Value

Description

xlAverage

-4106

Average.

xlCount

-4112

Count.

xlCountNums

-4113

Count numerical values only.

xlDistinctCount

111

Count using Distinct Count analysis.

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:
© 2016 Microsoft