Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Enum AggregationType Inherits System.Enum | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As AggregationType | |
| C# | |
|---|---|
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