XlTotalsCalculation Enumeration
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)
Syntax
'Declaration
Public Enumeration XlTotalsCalculation
'Usage
Dim instance As XlTotalsCalculation
public enum XlTotalsCalculation
Members
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 |