The Subtotal feature in Excel allows you to quickly organize and summarize large datasets by inserting calculation rows at each change in a specific category.
نفّذه بالذكاء الاصطناعيSort your data
Click any cell in the column you want to group by and sort the data in ascending or descending order.
Open the Subtotal tool
Go to the 'Data' tab on the ribbon and click the 'Subtotal' button in the 'Outline' group.
Configure subtotal settings
In the dialog box, select the group column, choose the function (e.g., Sum), and check the columns you want to calculate.
Apply and view
Click 'OK' to insert the subtotal rows and use the outline buttons on the left to expand or collapse your data.
This usually happens if your data is formatted as an official Excel Table. Convert the table to a normal range first.