AggregationType Enumeration

Specifies the type of aggregation on ranges of cells.

Syntax

Visual Basic
C#

'Declaration
 
Public Enum AggregationType 
   Inherits System.Enum

'Usage
 
Dim instance As AggregationType

public enum AggregationType : System.Enum

Members

Member	Description
Avg	Returns the average of cells in a range.
Count	Counts the number of cells in a range that contain numbers.
CountA	Counts the number of cells in a range that are not empty.
Custom	Specifies custom aggregation.
Max	Returns the maximum value of cells in a range.
Min	Indicates the row count of the cells in the specified range of cells.
None	Indicates that aggregation for the sheet is not supported.
Product	Multiplies all the cells in a range and returns the product.
StDev	Returns the standard deviation for a set of cells in a range.
StDevP	Calculates standard deviation based on the entire population given as cells in a range.
Sum	Sums values of cells in a range.
Var	Calculates variance based on a sample of a population.
VarP	Calculates variance based on the entire population.

Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         FarPoint.Web.Spread.Model.AggregationType

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

FarPoint.Web.Spread.Model Namespace