Spread WPF 18
GrapeCity.Spreadsheet Namespace / CalculationEngine Class / Sum Method
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.


In This Topic
    Sum Method
    In This Topic
    Gets SUM of the specified range.
    Syntax
    'Declaration
     
    Public Shared Function Sum( _
       ByVal context As IEvaluationContext, _
       ByVal source As IReferenceSource, _
       ByVal row As Integer, _
       ByVal column As Integer, _
       ByVal row2 As Integer, _
       ByVal column2 As Integer _
    ) As Double
    'Usage
     
    Dim context As IEvaluationContext
    Dim source As IReferenceSource
    Dim row As Integer
    Dim column As Integer
    Dim row2 As Integer
    Dim column2 As Integer
    Dim value As Double
     
    value = CalculationEngine.Sum(context, source, row, column, row2, column2)
    public static double Sum( 
       IEvaluationContext context,
       IReferenceSource source,
       int row,
       int column,
       int row2,
       int column2
    )

    Parameters

    context
    source
    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.

    Return Value

    The total summary of the specified cell range.
    See Also