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