New to Telerik Document Processing? Start a free 30-day trial

SumIf

Class

Implements the SUMIF function, which sums values in a range that meet a specified criteria.

Definition

Namespace:Telerik.Documents.Spreadsheet.Expressions.Functions

Assembly:Telerik.Windows.Documents.Spreadsheet.dll

Syntax:

public class SumIf : FunctionWithArguments

Inheritance: objectFunctionBaseFunctionWithArgumentsSumIf

Inherited Members FunctionWithArguments.EvaluateOverride(FunctionEvaluationContext<RadExpression>)FunctionWithArguments.EvaluateLiftedElement(FunctionEvaluationContext<RadExpression>, RadExpression[], int, int)FunctionBase.IsSpillingArgument(int, RadExpression)FunctionBase.Evaluate(FunctionEvaluationContext<RadExpression>)FunctionBase.IsArgumentNumberValid(int)

Constructors

SumIf()

Initializes a new instance of the SUMIF function.

public SumIf()

Fields

FunctionName

string

The name of the function.

public static readonly string FunctionName

Properties

ArgumentConversionRules

Gets the argument conversion rules.

public override ArgumentConversionRules ArgumentConversionRules { get; }

Property Value:

The argument conversion rules as ArgumentConversionRules.

Overrides: FunctionBase.ArgumentConversionRules

FunctionInfo

Gets the function info.

public override FunctionInfo FunctionInfo { get; }

Property Value:

The function info as FunctionInfo.

Overrides: FunctionBase.FunctionInfo

When true, FunctionBase automatically evaluates this function element-wise over any multi-element array argument and returns a spilled array result. Override to true in pure scalar functions (e.g. ABS, LEN, MOD) where applying the function independently to each element of an input array is the correct dynamic-array behavior. Leave false (the default) for reducers.

public override bool LiftsOverArrays { get; }

Overrides: FunctionBase.LiftsOverArrays

Name

string

Gets the name of the function.

public override string Name { get; }

Property Value:

The name as String.

Overrides: FunctionBase.Name

Methods

EvaluateOverride(FunctionEvaluationContext<object>)

Evaluates the SUMIF function and returns the sum of values matching the criteria.

protected override RadExpression EvaluateOverride(FunctionEvaluationContext<object> context)

Parameters:contextFunctionEvaluationContext<object>

The context.

Returns:

RadExpression

Functions result as RadExpression.

Overrides: FunctionWithArguments.EvaluateOverride(FunctionEvaluationContext<object>)