DCOUNT

Counts the cells that contain numbers in a database.


Database

/var/www/html/onswitch.neon/vendor/phpoffice/phpexcel/Documentation/Examples/Calculations/Database/DCOUNT.php:64:
array (size=7)
  4 => 
    array (size=5)
      'A' => string 'Tree' (length=4)
      'B' => string 'Height' (length=6)
      'C' => string 'Age' (length=3)
      'D' => string 'Yield' (length=5)
      'E' => string 'Profit' (length=6)
  5 => 
    array (size=5)
      'A' => string 'Apple' (length=5)
      'B' => float 18
      'C' => float 20
      'D' => float 14
      'E' => float 105
  6 => 
    array (size=5)
      'A' => string 'Pear' (length=4)
      'B' => float 12
      'C' => float 12
      'D' => float 10
      'E' => float 96
  7 => 
    array (size=5)
      'A' => string 'Cherry' (length=6)
      'B' => float 13
      'C' => float 14
      'D' => float 9
      'E' => float 105
  8 => 
    array (size=5)
      'A' => string 'Apple' (length=5)
      'B' => float 14
      'C' => float 15
      'D' => float 10
      'E' => float 75
  9 => 
    array (size=5)
      'A' => string 'Pear' (length=4)
      'B' => float 9
      'C' => float 8
      'D' => float 8
      'E' => float 76.8
  10 => 
    array (size=5)
      'A' => string 'Apple' (length=5)
      'B' => float 8
      'C' => float 9
      'D' => float 6
      'E' => float 45

Criteria

/var/www/html/onswitch.neon/vendor/phpoffice/phpexcel/Documentation/Examples/Calculations/Database/DCOUNT.php:74:
array (size=2)
  1 => 
    array (size=2)
      'A' => string 'Tree' (length=4)
      'B' => string 'Height' (length=6)
  2 => 
    array (size=2)
      'A' => string '=Apple' (length=6)
      'B' => string '>10' (length=3)
The Number of Apple trees over 10' in height
DCOUNT() Result is 2

Criteria

/var/www/html/onswitch.neon/vendor/phpoffice/phpexcel/Documentation/Examples/Calculations/Database/DCOUNT.php:82:
array (size=3)
  1 => 
    array (size=1)
      'A' => string 'Tree' (length=4)
  2 => 
    array (size=1)
      'A' => string '=Apple' (length=6)
  3 => 
    array (size=1)
      'A' => string '=Pear' (length=5)
The Number of Apple and Pear trees in the orchard
DCOUNT() Result is 5