Click or drag to resize

ExcelTableTotalsCalculation Enumeration

The function calculated in the totals row of a table column. Excel writes a SUBTOTAL formula that ignores the rows hidden by the table filter.

Namespace: ExpertXls.ExcelLib
Assembly: expertxls (in expertxls.dll) Version: 10.0.0
Syntax
public enum ExcelTableTotalsCalculation
Members
Member nameValueDescription
None0 No calculation; the totals row cell can show a label.
Sum1 The sum of the column values.
Average2 The average of the column values.
Count3 The number of non-empty cells.
CountNumbers4 The number of cells that contain numbers.
Min5 The smallest value.
Max6 The largest value.
StdDev7 The standard deviation of the values.
Var8 The variance of the values.
See Also