I ask how this is done EXCEL template

Users questions: EXCEL template shown in the left column there are several options 1,2,3, and the following list can also point to open, stacked into the relationship! Please experts help! Explain! Thank you!
Experts answer: This is a classified summary of the results of its operations as follows: 1, select the original table A2: M17. 2, "the number of According to the classification of fields * Subtotal * * * Summarize by contract number subtotal * count * * * Check suppliers 'results in the data summary below * OK' ", the result is as following table. Appendix: Classification Summary. xls
  • This information provided by the users.Thanks!