[Summary view]

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

   1  <?php
   2  
   3  namespace PhpOffice\PhpSpreadsheet\Calculation\Database;
   4  
   5  use PhpOffice\PhpSpreadsheet\Calculation\Statistical\Counts;
   6  
   7  class DCount extends DatabaseAbstract
   8  {
   9      /**
  10       * DCOUNT.
  11       *
  12       * Counts the cells that contain numbers in a column of a list or database that match conditions
  13       * that you specify.
  14       *
  15       * Excel Function:
  16       *        DCOUNT(database,[field],criteria)
  17       *
  18       * @param mixed[] $database The range of cells that makes up the list or database.
  19       *                                        A database is a list of related data in which rows of related
  20       *                                        information are records, and columns of data are fields. The
  21       *                                        first row of the list contains labels for each column.
  22       * @param null|int|string $field Indicates which column is used in the function. Enter the
  23       *                                        column label enclosed between double quotation marks, such as
  24       *                                        "Age" or "Yield," or a number (without quotation marks) that
  25       *                                        represents the position of the column within the list: 1 for
  26       *                                        the first column, 2 for the second column, and so on.
  27       * @param mixed[] $criteria The range of cells that contains the conditions you specify.
  28       *                                        You can use any range for the criteria argument, as long as it
  29       *                                        includes at least one column label and at least one cell below
  30       *                                        the column label in which you specify a condition for the
  31       *                                        column.
  32       *
  33       * @return int
  34       */
  35      public static function evaluate($database, $field, $criteria)
  36      {
  37          $field = self::fieldExtract($database, $field);
  38  
  39          return Counts::COUNT(
  40              self::getFilteredColumn($database, $field, $criteria)
  41          );
  42      }
  43  }