Salesperson sales performance statistics table

The statistical method of salesperson sales performance statistics table:

First, for products that adopt a delivery system, the sales volume will be calculated after completing the consignment procedures with the transportation department. The date stamp of the shipping unit shall be used as the basis for statistics.
Second, for products that adopt the pick-up system, the sales volume will be calculated after the payment settlement procedures are completed with the buyer and the delivery note is issued. The date on the delivery note shall be used for statistics.
Third, for products that use buyer classification, count the number of products sold according to their different classifications.

​​ 1. Sum: =SUM(K2:K56) Sum the area from K2 to K56;
​ ​ 2. Average: =AVERAGE(K2:K56) Find the average of the area K2 K56;
3. Ranking: =RANK(K2,K$2:KS56) ranks the results of 55 students;
​​ 4. Level: =IF(K2>=85, "Excellent", IF(K2>=74, "People", IF(K2>=60, "Pass", "Fail")))
5. Semester overall evaluation: =K2*0.3+M2*0.3+N2*0.4 Assume that column K, column M and column N respectively store the three grades of students: "usual overall evaluation", "midterm" and "final";
​ ​ 6. Highest score: =MAX(K2:K56) Find the highest score in the K2 to K56 area (55 students);
​ ​ 7. Minimum score: =MIN(K2:K56) ——- Find the lowest score in the K2 to K56 area (55 students);

      Salesperson sales performance statistics tableIt is a free Excel template, download it if you need it! Huajun Software Park provides high-quality Excel template downloads.Detailed income structure,income item budget tableDownload to get the source file, which you can edit, modify and replace. To download the salesperson sales performance statistics table, go to Huajun Software Park.