Subtotals on EXCEL
Users questions: Does the subtotal dialog EXCEL "classification field", "summary manner", "subtotal" how the definition of the meaning of what they were all mean? How flexible use? Thank you
Experts answer: in the "Category field," choose your column header to sort, such as the departments table Or coding. In the "summary manner", choose the count, sum, average, etc.. In the "subtotal", choose the items you want to summarize, as the table number, the amount of money. In fact, you just point to open the drop-down arrow to the right of each to see the list of which specific content can be less aware of their Intention of.