Office software is closely linked to the PDF,the PDF is also must have to control!
Set home Page Add to Favorites
|
2, table sales Table sales could be the integrated use of IF, SUMIF, COUNTIF very typical example. For example, sales staff may wish to calculate the number of orders, and then aggregate sales for each sales and shipments in accordance with the total sales in determining each of the prize money should be given. The raw data table as shown in Figure 9 (the original data is based on a single form of water, that is arranged by order number)
(1) orders - calculated using COUNTIF number of sales orders. To sales orders ANNIE formula as an example. Formula: = COUNTIF ($ C $ 2: $ C $ 13, A17) Grammar to explain the purpose of calculating the cell A17 (or sales ANNIE) in the "sales" a list of $ C $ 2: $ C $ 13 within the scope of (that is, as shown in Figure 9 of the original data sheets) of the number. The number appears to believe that the sales orders of ANNIE. (2) the total amount of orders - using SUMIF aggregate sales for each salesperson. ANNIE to sales orders as an example the total amount of formula. Formula: = SUMIF ($ C $ 2: $ C $ 13, A17, $ B $ 2: $ B $ 13) The formula in the "sales" a list of $ C $ 2: $ C $ 13 in cell A17 to check the text (that is, sales ANNIE), and then calculating the "amount of orders" out ($ B $ 2: $ B $ 13) in the corresponding volumeºÍ. And the corresponding volume of sales is the total amount of orders ANNIE. (3) sales bonuses - IF with each decision based on the total amount of sales orders should be given the prize. The assumption that the rules of the company's sales of money orders for when the total amount of more than 50,000 yuan, the incentive rate for the 15%, otherwise 10%. According to this rule is still ANNIE sales staff as an example. Formula: = IF (C17 <50000,10%, 15%) * C17 If the order is less than 50,000 total prize money of 10%; if the total orders greater than or equal to 50000, the bonus is 15%. At this point, we have full understanding of the logic function EXCEL function, I believe we will be in practice more useful to think of more use. |
