Search moodle.org's
Developer Documentation

See Release Notes

  • Bug fixes for general core bugs in 4.2.x will end 22 April 2024 (12 months).
  • Bug fixes for security issues in 4.2.x will end 7 October 2024 (18 months).
  • PHP version: minimum PHP 8.0.0 Note: minimum PHP version has increased since Moodle 4.1. PHP 8.1.x is supported too.
/lib/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Calculation/Database/ -> DSum.php (source)

[Source view]

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

(no description)

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

Defines 1 class

DSum:: (1 method):
  evaluate()


Class: DSum  - X-Ref

evaluate($database, $field, $criteria, bool $returnNull = false)   X-Ref
DSUM.

Adds the numbers in a column of a list or database that match conditions that you specify.

Excel Function:
DSUM(database,field,criteria)

param: mixed[] $database The range of cells that makes up the list or database.
param: int|string $field Indicates which column is used in the function. Enter the
param: mixed[] $criteria The range of cells that contains the conditions you specify.
return: null|float|string