DCOUNT
Counts the cells that contain numbers in a database.
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Shared/String.php on line 529
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Shared/String.php on line 530
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Shared/String.php on line 536
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Shared/String.php on line 536
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Shared/String.php on line 537
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Shared/String.php on line 537
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 2186
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 2186
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 2294
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 2294
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 2296
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 2372
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 2374
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 2383
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 2632
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 2761
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 2763
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 2764
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 3039
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 3039
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 3042
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 3043
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 3459
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 3459
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 3501
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 3505
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 3558
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 3559
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Worksheet/AutoFilter.php on line 729
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Worksheet/AutoFilter.php on line 729
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell.php on line 772
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell.php on line 773
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell.php on line 776
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell.php on line 777
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell.php on line 777
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell.php on line 779
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell.php on line 780
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell.php on line 780
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell.php on line 780
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell.php on line 784
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 86
Notice: Trying to access array offset on value of type int in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 86
Notice: Trying to access array offset on value of type int in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 86
Notice: Trying to access array offset on value of type int in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 86
Notice: Trying to access array offset on value of type float in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 86
Notice: Trying to access array offset on value of type int in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 86
Notice: Trying to access array offset on value of type int in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 86
Notice: Trying to access array offset on value of type int in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 86
Notice: Trying to access array offset on value of type float in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 86
Notice: Trying to access array offset on value of type int in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 86
Notice: Trying to access array offset on value of type int in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 86
Notice: Trying to access array offset on value of type int in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 86
Notice: Trying to access array offset on value of type float in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 86
Notice: Trying to access array offset on value of type int in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 86
Notice: Trying to access array offset on value of type int in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 86
Notice: Trying to access array offset on value of type int in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 86
Notice: Trying to access array offset on value of type float in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 86
Notice: Trying to access array offset on value of type int in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 86
Notice: Trying to access array offset on value of type int in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 86
Notice: Trying to access array offset on value of type int in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 86
Notice: Trying to access array offset on value of type float in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 86
Notice: Trying to access array offset on value of type int in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 86
Notice: Trying to access array offset on value of type int in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 86
Notice: Trying to access array offset on value of type int in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 86
Notice: Trying to access array offset on value of type float in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 86
Database
array(7) {
[4]=>
array(5) {
["A"]=>
string(4) "Tree"
["B"]=>
string(6) "Height"
["C"]=>
string(3) "Age"
["D"]=>
string(5) "Yield"
["E"]=>
string(6) "Profit"
}
[5]=>
array(5) {
["A"]=>
string(5) "Apple"
["B"]=>
float(18)
["C"]=>
float(20)
["D"]=>
float(14)
["E"]=>
float(105)
}
[6]=>
array(5) {
["A"]=>
string(4) "Pear"
["B"]=>
float(12)
["C"]=>
float(12)
["D"]=>
float(10)
["E"]=>
float(96)
}
[7]=>
array(5) {
["A"]=>
string(6) "Cherry"
["B"]=>
float(13)
["C"]=>
float(14)
["D"]=>
float(9)
["E"]=>
float(105)
}
[8]=>
array(5) {
["A"]=>
string(5) "Apple"
["B"]=>
float(14)
["C"]=>
float(15)
["D"]=>
float(10)
["E"]=>
float(75)
}
[9]=>
array(5) {
["A"]=>
string(4) "Pear"
["B"]=>
float(9)
["C"]=>
float(8)
["D"]=>
float(8)
["E"]=>
float(76.8)
}
[10]=>
array(5) {
["A"]=>
string(5) "Apple"
["B"]=>
float(8)
["C"]=>
float(9)
["D"]=>
float(6)
["E"]=>
float(45)
}
}
Criteria
Notice: Trying to access array offset on value of type null in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation.php on line 2958
array(2) {
[1]=>
array(2) {
["A"]=>
string(4) "Tree"
["B"]=>
string(6) "Height"
}
[2]=>
array(2) {
["A"]=>
string(6) "=Apple"
["B"]=>
string(3) ">10"
}
}
The Number of Apple trees over 10' in height
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation/Functions.php on line 311
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation/Functions.php on line 313
Deprecated: Array and string offset access syntax with curly braces is deprecated in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation/Functions.php on line 534
Fatal error: 'break' not in the 'loop' or 'switch' context in /home/asosupro/public_html/backend/views/layouts/inc/excel/Classes/PHPExcel/Calculation/Functions.php on line 581