PivotTableField.SummarizeByType

Description

The SummarizeByType class contains the Excel value field summarize by types supported by ExcelWriter.

C#

vb.net

Name	Description
Average	The average of the values.
Count	The number of data values. works the same as the COUNTA worksheet function.
CountNumbers	The number of data values that are numbers. Works the same as the COUNT worksheet function.
Max	The largest value.
Min	The smallest value.
Product	The product of the values.
StdDev	An estimate of the standard deviation of a population, where the sample is a subset of the entire population.
StdDevp	The standard deviation of a population, where the population is all of the data to be summarized.
Sum	The sum of the values.
Var	An estimate of the variance of a population, where the sample is a subset of the entire population.
Varp	The variance of a population, where the population is all of the data to be summarized.