GetAggregate Method

In This Topic

Calculates aggregate statistics for a cell range.

Syntax

'Declaration
 
Public Overridable Function GetAggregate( _
   ByVal aggregate As Aggregate, _
   ByVal rng As CellRange _
) As Decimal

public virtual decimal GetAggregate( 
   Aggregate aggregate,
   CellRange rng
)

aggregate: Aggregate value that specifies the type of aggregate to calculate.
rng: CellRange object that contains the values to be aggregated.

A decimal value that represents the aggregate.

Remarks

Cells in invisible rows and columns are included in the aggregate calculations; cells in group rows are not.