Collapse the table of content
Expand the table of content
Expand Minimize

XlTotalsCalculation Enumeration (Excel)

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

Version Added: Excel 2007

Name

Value

Description

xlTotalsCalculationAverage

2

Average

xlTotalsCalculationCount

3

Count of non-empty cells

xlTotalsCalculationCountNums

4

Count of cells with numeric values

xlTotalsCalculationCustom

9

Custom calculation

xlTotalsCalculationMax

6

Maximum value in the list

xlTotalsCalculationMin

5

Minimum value in the list

xlTotalsCalculationNone

0

No calculation

xlTotalsCalculationStdDev

7

Standard deviation value

xlTotalsCalculationSum

1

Sum of all values in the list column

xlTotalsCalculationVar

8

Variable

Show:
© 2015 Microsoft