public IPrimitiveValue Aggregate( 
   AggregateFunction func,
   int row,
   int column,
   int row2,
   int column2,
   AggregateOption option
)

'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

Reference

Worksheet Class
Worksheet Members
Overload List