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.ExcelLibAssembly: expertxls (in expertxls.dll) Version: 10.0.0
Syntaxpublic enum ExcelTableTotalsCalculation
Public Enumeration ExcelTableTotalsCalculation
Members| Member name | Value | Description |
|---|
| None | 0 |
No calculation; the totals row cell can show a label.
|
| Sum | 1 |
The sum of the column values.
|
| Average | 2 |
The average of the column values.
|
| Count | 3 |
The number of non-empty cells.
|
| CountNumbers | 4 |
The number of cells that contain numbers.
|
| Min | 5 |
The smallest value.
|
| Max | 6 |
The largest value.
|
| StdDev | 7 |
The standard deviation of the values.
|
| Var | 8 |
The variance of the values.
|
See Also