XlTotalsCalculation enumeration
Office 2013 and later
Specifies the type of calculation in the Totals row of a list column.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
| Member name | Description | |
|---|---|---|
| xlTotalsCalculationNone | No calculation. | |
| xlTotalsCalculationSum | Sum. | |
| xlTotalsCalculationAverage | Average. | |
| xlTotalsCalculationCount | Count of non-empty cells. | |
| xlTotalsCalculationCountNums | Count of cells with numeric values. | |
| xlTotalsCalculationMin | Minimum value. | |
| xlTotalsCalculationMax | Maximum value. | |
| xlTotalsCalculationStdDev | Standard deviation. | |
| xlTotalsCalculationVar | Variance. | |
| xlTotalsCalculationCustom | Custom calculation |
Show: