Export (0) Print
Expand All
Expand Minimize

XlTotalsCalculation Enumeration

Office 2007
Specifies the type of calculation in the Totals row of a list column.

Version Information
 Version Added:  Excel 2007

NameValueDescription
xlTotalsCalculationAverage2Average
xlTotalsCalculationCount3Count of non-empty cells
xlTotalsCalculationCountNums4Count of cells with numeric values
xlTotalsCalculationCustom9Custom calculation
xlTotalsCalculationMax6Maximum value in the list
xlTotalsCalculationMin5Minimum value in the list
xlTotalsCalculationNone0No calculation
xlTotalsCalculationStdDev7Standard deviation value
xlTotalsCalculationSum1Sum of all values in the list column
xlTotalsCalculationVar8Variable


Community Additions

ADD
Show:
© 2014 Microsoft