{oapdf_gg}
(4) As the second asked for the sake of the largest apple and pear profits, so re-establishment of a query - pear, as shown in Fig. = DMAX (A4: E10, "Profit", A1: A3) to derive the largest apple and pear profit 105 = DMIN (A4: E10, "Profit", A1: B2) obtained more than 10 feet high minimum profit of apple trees 75 (6) can be obtained using DSUM function of the total profits of all the apple trees. Formula: = DSUM (A4: E10, "Profit", A1: A2) the total profit of 225 (7) asked other similar functions can be used to solve in detail the formula as shown. |