xlConsolidationFunction |
| Specifies the subtotal function. |
| xlAverage | Average (-4106) |
| xlCount | Count (-4112) |
| xlCountNums | Count numerical values only (-4113) |
| xlDistinctCount | (Added in 2013) Count using Distinct Count analysis (11) |
| xlMax | Maximum (-4136) |
| xlMin | Minimum (-4139) |
| xlProduct | Multiply (-4149) |
| xlStDev | Standard deviation, based on a sample (-4155) |
| xlStDevP | Standard deviation, based on the whole population (-4156) |
| xlSum | Sum (-4157) |
| xlUnknown | No subtotal function specified (1000) |
| xlVar | Variation, based on a sample (-4164) |
| xlVarP | Variation, based on the whole population (-4165) |
| xlAverage |
| Average (-4106) |
| xlCount |
| Count (-4112) |
| xlCountNums |
| Count numerical values only (-4113) |
| xlDistinctCount |
| (Added in 2013) Count using Distinct Count analysis (11) |
| xlMax |
| Maximum (-4136) |
| xlMin |
| Minimum (-4139) |
| xlProduct |
| Multiply (-4149) |
| xlStDev |
| Standard deviation, based on a sample (-4155) |
| xlStDevP |
| Standard deviation, based on the whole population (-4156) |
| xlSum |
| Sum (-4157) |
| xlUnknown |
| No subtotal function specified (1000) |
| xlVar |
| Variation, based on a sample (-4164) |
| xlVarP |
| Variation, based on the whole population (-4165) |
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited Top