DAVERAGE

16:30:19 Returns the average of selected database entries.
16:30:19 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"]=> int(18) ["C"]=> int(20) ["D"]=> int(14) ["E"]=> float(105) } [6]=> array(5) { ["A"]=> string(4) "Pear" ["B"]=> int(12) ["C"]=> int(12) ["D"]=> int(10) ["E"]=> float(96) } [7]=> array(5) { ["A"]=> string(6) "Cherry" ["B"]=> int(13) ["C"]=> int(14) ["D"]=> int(9) ["E"]=> float(105) } [8]=> array(5) { ["A"]=> string(5) "Apple" ["B"]=> int(14) ["C"]=> int(15) ["D"]=> int(10) ["E"]=> float(75) } [9]=> array(5) { ["A"]=> string(4) "Pear" ["B"]=> int(9) ["C"]=> int(8) ["D"]=> int(8) ["E"]=> float(76.8) } [10]=> array(5) { ["A"]=> string(5) "Apple" ["B"]=> int(8) ["C"]=> int(9) ["D"]=> int(6) ["E"]=> float(45) } } 16:30:19 Criteria
array(2) { [1]=> array(2) { ["A"]=> string(4) "Tree" ["B"]=> string(6) "Height" } [2]=> array(2) { ["A"]=> string(6) "=Apple" ["B"]=> string(3) ">10" } } 16:30:19 The Average yield of Apple trees over 10' in height
16:30:19 DAVERAGE() Result is 12
16:30:19 Criteria
array(3) { [1]=> array(1) { ["A"]=> string(4) "Tree" } [2]=> array(1) { ["A"]=> string(6) "=Apple" } [3]=> array(1) { ["A"]=> string(5) "=Pear" } } 16:30:19 The Average age of all Apple and Pear trees in the orchard
16:30:19 DAVERAGE() Result is 12.8