XlTotalsCalculation XlTotalsCalculation XlTotalsCalculation Enum

Definition

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

public enum class XlTotalsCalculation
public enum XlTotalsCalculation
Public Enum XlTotalsCalculation
Inheritance
XlTotalsCalculationXlTotalsCalculationXlTotalsCalculation

Fields

xlTotalsCalculationAverage xlTotalsCalculationAverage xlTotalsCalculationAverage 2

Average.

xlTotalsCalculationCount xlTotalsCalculationCount xlTotalsCalculationCount 3

Count of non-empty cells.

xlTotalsCalculationCountNums xlTotalsCalculationCountNums xlTotalsCalculationCountNums 4

Count of cells with numeric values.

xlTotalsCalculationCustom xlTotalsCalculationCustom xlTotalsCalculationCustom 9

Custom calculation

xlTotalsCalculationMax xlTotalsCalculationMax xlTotalsCalculationMax 6

Maximum value.

xlTotalsCalculationMin xlTotalsCalculationMin xlTotalsCalculationMin 5

Minimum value.

xlTotalsCalculationNone xlTotalsCalculationNone xlTotalsCalculationNone 0

No calculation.

xlTotalsCalculationStdDev xlTotalsCalculationStdDev xlTotalsCalculationStdDev 7

Standard deviation.

xlTotalsCalculationSum xlTotalsCalculationSum xlTotalsCalculationSum 1

Sum.

xlTotalsCalculationVar xlTotalsCalculationVar xlTotalsCalculationVar 8

Variance.

Applies to