How To Insert Subtotals In A Sorted Data (Video transcript)
If want to have a subtotal for each department, we can manually insert a formula to get the subtotals for each department. However, have a dynamic tool to get the subtotals.
We have subtotal features and the data management menu. We must sort the data ahead of time if we expect coherent results. We have to sort the data in the last lecture.
Here let’s select the department (that means whenever the department is changed the subtotals will be changed and we can select the function sum, and subtotal to we add also the years of service. Click ok and see the result.
Now we have the subtotals for each department. We can go we step shorter to see only the department and here we have condensed data.
If we want to copy this data to a new sheet, we can go home and Find and select, go to Special, and select visible cells only and paste it to new sheet.