Summary of data in groups in Excel
The following article provides detailed instructions for you to aggregate data in groups in Excel.
With a large amount of data, statistical data is very complicated. Here, Excel 2013 supports the Subtotal feature, which helps you to aggregate data by group, thereby producing a more detailed, complete and accurate report:
Step 1: Click the mouse at any cell in the data range you want to aggregate -> Data -> Outline -> Subtotal:
Step 2: The Subtotal dialog box appears as follows:
- Item Add each change in: Select the field to be grouped, for example, here select the group by domain.
- Use Function: Select the function to use for summarizing, for example, use the function to calculate the average value Average -> calculate the average value of the number and revenue of employees.
- Add subtotal to section: Select the data field to sum, here calculate the average value of the number and revenue to be checked in columns D and E:
Step 3: After clicking OK, the result is as shown in the picture:
- You can customize the data more visually:
- The data is aggregated by region, ending 3 regions as the aggregate value for the North, Central and South.
- Excel supports Subtotal 's minimized toolbar in the upper left corner of the screen. With a large volume of data, click No. 1 -> Show the average of the total data of all groups:
- Click the number 2 -> to display aggregated values for each group and the combined total value for all groups:
The above is a detailed guide on how to aggregate data in groups in Excel 2013.
Good luck!
You should read it
- Summary of 50 Excel shortcuts you should know by 2023
- Summary of data functions in Excel
- Summary of 50 most popular Ctrl-using shortcuts in Excel
- How to use ISEVEN and ISODD functions in Excel
- Summary of data from multiple Sheets in Excel
- Summary of Shortcut Keys in Excel for Mac / Windows
- Summary keyboard shortcuts in Excel
- How to draw a pie chart in Excel 2016
- Summary of tips, good Excel tips for accounting people
- Instructions for using PivotTable in Excel - How to use PivotTable
- Summary of information functions in Excel
- Summary of ways to delete blank lines in Excel 2007, 2010, 2013
Maybe you are interested
How to master numerical data in Google Sheets with the AVERAGE function
How to delete white space in a table in Word - Appears right below the data
Detected a new data theft campaign targeting AnyDesk users
How to update Excel PivotTable data
Detection of malicious code infecting the web browsers of 300,000 PCs, silently stealing user data
One of the worst data leaks in the history of cybersecurity has just been exposed