CONDITION_COLUMN_NAME
CONDITION_COLUMN_NAME = 'CONDITION'
AVERAGEIF(array $range, string $condition, array $averageRange = []) : null|float|string
AVERAGEIF.
Returns the average value from a range of cells that contain numbers within the list of arguments
Excel Function: AVERAGEIF(range,condition[, average_range])
| array | $range | Data values |
| string | $condition | the criteria that defines which cells will be checked |
| array | $averageRange | Data values |
AVERAGEIFS(mixed ...$args) : null|float|string
AVERAGEIFS.
Counts the number of cells that contain numbers within the list of arguments
Excel Function: AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2]…)
| mixed | $args variadic | Pairs of Ranges and Criteria |
COUNTIF(array $range, string $condition) : int
COUNTIF.
Counts the number of cells that contain numbers within the list of arguments
Excel Function: COUNTIF(range,condition)
| array | $range | Data values |
| string | $condition | the criteria that defines which cells will be counted |
MAXIFS(mixed ...$args) : null|float|string
MAXIFS.
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]…)
| mixed | $args variadic | Pairs of Ranges and Criteria |
MINIFS(mixed ...$args) : null|float|string
MINIFS.
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]…)
| mixed | $args variadic | Pairs of Ranges and Criteria |
SUMIFS(mixed ...$args) : null|float|string
SUMIFS.
Counts the number of cells that contain numbers within the list of arguments
Excel Function: SUMIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2]…)
| mixed | $args variadic | Pairs of Ranges and Criteria |