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, array<string|int, mixed>>
- buildConditionSet() : array<string|int, array<string|int, mixed>>
- buildConditionSetForValueRange() : array<string|int, 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, expect array
- $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|stringAVERAGEIFS()
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|stringCOUNTIF()
COUNTIF.
public
static COUNTIF(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 : mixed
-
Data values, expect array
- $condition : null|array<string|int, mixed>|string
-
the criteria that defines which cells will be counted
Return values
string|intCOUNTIFS()
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|stringMAXIFS()
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|stringMINIFS()
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|stringSUMIF()
SUMIF.
public
static SUMIF(mixed $range, mixed $condition[, 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 : mixed
-
Data values, expecting array
- $condition : mixed
- $sumRange : mixed = []
-
Data values, expecting array
Return values
null|float|stringSUMIFS()
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|stringbuildConditions()
private
static buildConditions(int $startOffset, array<string|int, mixed> ...$args) : array<string|int, array<string|int, mixed>>
Parameters
- $startOffset : int
- $args : array<string|int, mixed>
Return values
array<string|int, array<string|int, mixed>>buildConditionSet()
private
static buildConditionSet(array<string|int, mixed> ...$args) : array<string|int, array<string|int, mixed>>
Parameters
- $args : array<string|int, mixed>
Return values
array<string|int, array<string|int, mixed>>buildConditionSetForValueRange()
private
static buildConditionSetForValueRange(array<string|int, mixed> ...$args) : array<string|int, array<string|int, mixed>>
Parameters
- $args : array<string|int, mixed>
Return values
array<string|int, 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, array<string|int, mixed>> $database, array<string|int, mixed> ...$args) : array<string|int, mixed>
Parameters
- $startOffset : int
- $database : array<string|int, 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> = []