Share via


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