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