Skip to main content

XlConsolidationFunction enumeration

Specifies the subtotal function.

Name Value Description
xlAverage -4106 Average.
xlCount -4112 Count.
xlCountNums -4113 Count numerical values only.
xlDistinctCount 11 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.

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>