Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
XlTotalsCalculation Enumeration
Collapse the table of content
Expand the table of content

XlTotalsCalculation Enumeration

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