Search moodle.org's
Developer Documentation

See Release Notes
Long Term Support Release

  • Bug fixes for general core bugs in 4.1.x will end 13 November 2023 (12 months).
  • Bug fixes for security issues in 4.1.x will end 10 November 2025 (36 months).
  • PHP version: minimum PHP 7.4.0 Note: minimum PHP version has increased since Moodle 4.0. PHP 8.0.x is supported too.
/lib/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Calculation/Statistical/ -> Conditional.php (source)

[Source view]

Differences Between: [Versions 401 and 402] [Versions 401 and 403]

(no description)

File Size: 304 lines (9 kb)
Included or required:0 times
Referenced: 0 times
Includes or requires: 0 files

Defines 1 class

Conditional:: (15 methods):
  AVERAGEIF()
  AVERAGEIFS()
  COUNTIF()
  COUNTIFS()
  MAXIFS()
  MINIFS()
  SUMIF()
  SUMIFS()
  buildConditionSet()
  buildConditionSetForValueRange()
  buildConditions()
  buildDatabase()
  buildDatabaseWithValueRange()
  buildDataSet()
  databaseFromRangeAndValue()


Class: Conditional  - X-Ref

AVERAGEIF($range, $condition, $averageRange = [])   X-Ref
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])

param: mixed[] $range Data values
param: string $condition the criteria that defines which cells will be checked
param: mixed[] $averageRange Data values
return: null|float|string

AVERAGEIFS(...$args)   X-Ref
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]…)

param: mixed $args Pairs of Ranges and Criteria
return: null|float|string

COUNTIF($range, $condition)   X-Ref
COUNTIF.

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

Excel Function:
COUNTIF(range,condition)

param: mixed[] $range Data values
param: string $condition the criteria that defines which cells will be counted
return: int

COUNTIFS(...$args)   X-Ref
No description

MAXIFS(...$args)   X-Ref
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]…)

param: mixed $args Pairs of Ranges and Criteria
return: null|float|string

MINIFS(...$args)   X-Ref
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]…)

param: mixed $args Pairs of Ranges and Criteria
return: null|float|string

SUMIF($range, $condition, $sumRange = [])   X-Ref
SUMIF.

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

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

param: mixed $range Data values
param: mixed $sumRange
param: mixed $condition
return: float|string

SUMIFS(...$args)   X-Ref
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]…)

param: mixed $args Pairs of Ranges and Criteria
return: null|float|string

buildConditionSet(...$args)   X-Ref
No description

buildConditionSetForValueRange(...$args)   X-Ref
No description

buildConditions(int $startOffset, ...$args)   X-Ref
No description

buildDatabase(...$args)   X-Ref
No description

buildDatabaseWithValueRange(...$args)   X-Ref
No description

buildDataSet(int $startOffset, array $database, ...$args)   X-Ref
No description

databaseFromRangeAndValue(array $range, array $valueRange = [])   X-Ref
No description