Spread Windows Forms 17
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace / Worksheet Class / Aggregate Method / Aggregate(AggregateFunction,Int32,Int32,Int32,Int32,AggregateOption) Method
An GrapeCity.CalcEngine.AggregateFunction value indicates the aggregate function.
An integer value indicates the top row index of cell range.
An integer value indicates the left column index of cell range.
An integer value indicates the bottom row index of cell range.
An integer value indicates the right column index of cell range.
An GrapeCity.CalcEngine.AggregateOption value indicates which values to ignore in the evaluation range for the function.


In This Topic
    Aggregate(AggregateFunction,Int32,Int32,Int32,Int32,AggregateOption) Method
    In This Topic
    Get the aggregate value of the specified cell range.
    Syntax
    'Declaration
     
    
    Public Overloads Function Aggregate( _
       ByVal func As AggregateFunction, _
       ByVal row As Integer, _
       ByVal column As Integer, _
       ByVal row2 As Integer, _
       ByVal column2 As Integer, _
       Optional ByVal option As AggregateOption _
    ) As IPrimitiveValue
    'Usage
     
    
    Dim instance As Worksheet
    Dim func As AggregateFunction
    Dim row As Integer
    Dim column As Integer
    Dim row2 As Integer
    Dim column2 As Integer
    Dim option As AggregateOption
    Dim value As IPrimitiveValue
     
    value = instance.Aggregate(func, row, column, row2, column2, option)

    Parameters

    func
    An GrapeCity.CalcEngine.AggregateFunction value indicates the aggregate function.
    row
    An integer value indicates the top row index of cell range.
    column
    An integer value indicates the left column index of cell range.
    row2
    An integer value indicates the bottom row index of cell range.
    column2
    An integer value indicates the right column index of cell range.
    option
    An GrapeCity.CalcEngine.AggregateOption value indicates which values to ignore in the evaluation range for the function.

    Return Value

    An GrapeCity.CalcEngine.IPrimitiveValue object represents the aggregate value of the specified cell range.
    See Also