XlTotalsCalculation Enumeration
Specifies the type of calculation in the Totals row of a list column.
Version Information
Version Added: Excel 2007
| Name | Value | Description |
|---|---|---|
| xlTotalsCalculationAverage | 2 | Average |
| xlTotalsCalculationCount | 3 | Count of non-empty cells |
| xlTotalsCalculationCountNums | 4 | Count of cells with numeric values |
| xlTotalsCalculationCustom | 9 | Custom calculation |
| xlTotalsCalculationMax | 6 | Maximum value in the list |
| xlTotalsCalculationMin | 5 | Minimum value in the list |
| xlTotalsCalculationNone | 0 | No calculation |
| xlTotalsCalculationStdDev | 7 | Standard deviation value |
| xlTotalsCalculationSum | 1 | Sum of all values in the list column |
| xlTotalsCalculationVar | 8 | Variable |