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

CountIf

Class

Implements the COUNTIF function, which counts cells in a range that meet a specified criteria.

Definition

Namespace:Telerik.Documents.Spreadsheet.Expressions.Functions

Assembly:Telerik.Windows.Documents.Spreadsheet.dll

Syntax:

public class CountIf : FunctionWithArguments

Inheritance: objectFunctionBaseFunctionWithArgumentsCountIf

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

CountIf()

Initializes a new instance of the COUNTIF function.

public CountIf()

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 COUNTIF function and returns the count of cells matching the criteria. When the criteria argument is a multi-cell range or a multi-element array, an array of counts is returned (one count per criteria element) so that the formula can spill.

protected override RadExpression EvaluateOverride(FunctionEvaluationContext<object> context)

Parameters:contextFunctionEvaluationContext<object>

The context.

Returns:

RadExpression

Functions result as RadExpression.

Overrides: FunctionWithArguments.EvaluateOverride(FunctionEvaluationContext<object>)