Documentation

Conditional
in package

Table of Contents

Constants

CONDITION_COLUMN_NAME  = 'CONDITION'
CONDITIONAL_COLUMN_NAME  = 'CONDITIONAL %d'
VALUE_COLUMN_NAME  = 'VALUE'

Methods

AVERAGEIF()  : null|int|float|string
AVERAGEIF.
AVERAGEIFS()  : null|int|float|string
AVERAGEIFS.
COUNTIF()  : string|int
COUNTIF.
COUNTIFS()  : int|string
COUNTIFS.
MAXIFS()  : null|float|string
MAXIFS.
MINIFS()  : null|float|string
MINIFS.
SUMIF()  : null|float|string
SUMIF.
SUMIFS()  : null|float|string
SUMIFS.
buildConditions()  : array<string|int, mixed>
buildConditionSet()  : array<string|int, mixed>
buildConditionSetForValueRange()  : array<string|int, mixed>
buildDatabase()  : array<string|int, mixed>
buildDatabaseWithValueRange()  : array<string|int, mixed>
buildDataSet()  : array<string|int, mixed>
databaseFromRangeAndValue()  : array<string|int, mixed>

Constants

CONDITION_COLUMN_NAME

private mixed CONDITION_COLUMN_NAME = 'CONDITION'

CONDITIONAL_COLUMN_NAME

private mixed CONDITIONAL_COLUMN_NAME = 'CONDITIONAL %d'

VALUE_COLUMN_NAME

private mixed VALUE_COLUMN_NAME = 'VALUE'

Methods

AVERAGEIF()

AVERAGEIF.

public static AVERAGEIF(mixed $range, null|array<string|int, mixed>|string $condition[, mixed $averageRange = [] ]) : null|int|float|string

Returns the average value from a range of cells that contain numbers within the list of arguments

Excel Function: AVERAGEIF(range,condition[, average_range])

Parameters
$range : mixed

Data values

$condition : null|array<string|int, mixed>|string

the criteria that defines which cells will be checked

$averageRange : mixed = []

Data values

Return values
null|int|float|string

AVERAGEIFS()

AVERAGEIFS.

public static AVERAGEIFS(mixed ...$args) : null|int|float|string

Counts the number of cells that contain numbers within the list of arguments

Excel Function: AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2]…)

Parameters
$args : mixed

Pairs of Ranges and Criteria

Return values
null|int|float|string

COUNTIF()

COUNTIF.

public static COUNTIF(array<string|int, mixed> $range, null|array<string|int, mixed>|string $condition) : string|int

Counts the number of cells that contain numbers within the list of arguments

Excel Function: COUNTIF(range,condition)

Parameters
$range : array<string|int, mixed>

Data values

$condition : null|array<string|int, mixed>|string

the criteria that defines which cells will be counted

Return values
string|int

COUNTIFS()

COUNTIFS.

public static COUNTIFS(mixed ...$args) : int|string

Counts the number of cells that contain numbers within the list of arguments

Excel Function: COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)

Parameters
$args : mixed

Pairs of Ranges and Criteria

Return values
int|string

MAXIFS()

MAXIFS.

public static MAXIFS(mixed ...$args) : null|float|string

Returns the maximum value within a range of cells that contain numbers within the list of arguments

Excel Function: MAXIFS(max_range, criteria_range1, criteria1, [criteria_range2, criteria2]…)

Parameters
$args : mixed

Pairs of Ranges and Criteria

Return values
null|float|string

MINIFS()

MINIFS.

public static MINIFS(mixed ...$args) : null|float|string

Returns the minimum value within a range of cells that contain numbers within the list of arguments

Excel Function: MINIFS(min_range, criteria_range1, criteria1, [criteria_range2, criteria2]…)

Parameters
$args : mixed

Pairs of Ranges and Criteria

Return values
null|float|string

SUMIF()

SUMIF.

public static SUMIF(array<string|int, mixed> $range, mixed $condition[, array<string|int, mixed> $sumRange = [] ]) : null|float|string

Totals the values of cells that contain numbers within the list of arguments

Excel Function: SUMIF(range, criteria, [sum_range])

Parameters
$range : array<string|int, mixed>

Data values

$condition : mixed
$sumRange : array<string|int, mixed> = []
Return values
null|float|string

SUMIFS()

SUMIFS.

public static SUMIFS(mixed ...$args) : null|float|string

Counts the number of cells that contain numbers within the list of arguments

Excel Function: SUMIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2]…)

Parameters
$args : mixed

Pairs of Ranges and Criteria

Return values
null|float|string

buildConditions()

private static buildConditions(int $startOffset, array<string|int, mixed> ...$args) : array<string|int, mixed>
Parameters
$startOffset : int
$args : array<string|int, mixed>
Return values
array<string|int, mixed>

buildConditionSet()

private static buildConditionSet(array<string|int, mixed> ...$args) : array<string|int, mixed>
Parameters
$args : array<string|int, mixed>
Return values
array<string|int, mixed>

buildConditionSetForValueRange()

private static buildConditionSetForValueRange(array<string|int, mixed> ...$args) : array<string|int, mixed>
Parameters
$args : array<string|int, mixed>
Return values
array<string|int, mixed>

buildDatabase()

private static buildDatabase(array<string|int, mixed> ...$args) : array<string|int, mixed>
Parameters
$args : array<string|int, mixed>
Return values
array<string|int, mixed>

buildDatabaseWithValueRange()

private static buildDatabaseWithValueRange(array<string|int, mixed> ...$args) : array<string|int, mixed>
Parameters
$args : array<string|int, mixed>
Return values
array<string|int, mixed>

buildDataSet()

private static buildDataSet(int $startOffset, array<string|int, mixed> $database, array<string|int, mixed> ...$args) : array<string|int, mixed>
Parameters
$startOffset : int
$database : array<string|int, mixed>
$args : array<string|int, mixed>
Return values
array<string|int, mixed>

databaseFromRangeAndValue()

private static databaseFromRangeAndValue(array<string|int, mixed> $range[, array<string|int, mixed> $valueRange = [] ]) : array<string|int, mixed>
Parameters
$range : array<string|int, mixed>
$valueRange : array<string|int, mixed> = []
Return values
array<string|int, mixed> 

        

        
    




    

    

                                

                

                                
    

        On this page

        
    


                

                            

            

    

        

            
Search results