XlTotalsCalculation Enum

Definition

Namespace:

Microsoft.Office.Interop.Excel

Assembly:

Microsoft.Office.Interop.Excel.dll

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

public enum class XlTotalsCalculation

public enum XlTotalsCalculation

Public Enum XlTotalsCalculation

Inheritance

Enum

XlTotalsCalculation

Fields

Name	Value	Description
xlTotalsCalculationNone	0	No calculation.
xlTotalsCalculationSum	1	Sum.
xlTotalsCalculationAverage	2	Average.
xlTotalsCalculationCount	3	Count of non-empty cells.
xlTotalsCalculationCountNums	4	Count of cells with numeric values.
xlTotalsCalculationMin	5	Minimum value.
xlTotalsCalculationMax	6	Maximum value.
xlTotalsCalculationStdDev	7	Standard deviation.
xlTotalsCalculationVar	8	Variance.
xlTotalsCalculationCustom	9	Custom calculation