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)

Usage

Dim xlTotalsCalculation1 As XlTotalsCalculation = XlTotalsCalculation.xlTotalsCalculationAverage

Syntax

Public Enum XlTotalsCalculation
public enum XlTotalsCalculation
public enum class XlTotalsCalculation
public enum XlTotalsCalculation
public enum XlTotalsCalculation

Members

Member name Description
xlTotalsCalculationAverage Average.
xlTotalsCalculationCount Count of non-empty cells.
xlTotalsCalculationCountNums Count of cells with numeric values.
xlTotalsCalculationMax Maximum value.
xlTotalsCalculationMin Minimum value.
xlTotalsCalculationNone No calculation.
xlTotalsCalculationStdDev Standard deviation.
xlTotalsCalculationSum Sum.
xlTotalsCalculationVar Variance.

Platforms

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms

See Also

Reference

Microsoft.Office.Interop.Excel Namespace