Share via

ListColumn.TotalsCalculation Property

  • Article
Excel Developer Reference

Determines the type of calculation in the Totals row of the list column based on the value of the XlTotalsCalculation enumeration. Read/write.

Syntax

expression.TotalsCalculation

expression   A variable that represents a ListColumn object.

Remarks

XlTotalsCalculation can be one of these XlTotalsCalculation constants.
xlTotalsCalculationNone
xlTotalsCalculationSum
xlTotalsCalculationAverage
xlTotalsCalculationCount
xlTotalsCalculationCountNums
xlTotalsCalculationMin
xlTotalsCalculationStdDev
xlTotalsCalculationVar
xlTotalsCalculationMax

The Totals row doesn't need to be showing in order to set this property. There is no fixed "default" value for this property. Excel may change the state of this property, as other columns are added or deleted.

Example

Visual Basic for Applications 
  ActiveSheet.ListColumns(1).TotalsCalculation=xlTotalsCalculationSum

See Also