'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)
public IPrimitiveValue Aggregate( AggregateFunction func, int row, int column, int row2, int column2, AggregateOption 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.