Szerkesztés

Megosztás a következőn keresztül:


XlConsolidationFunction enumeration (Excel)

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.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.