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 get data from web into Excel
What information does a VPN hide? How does it protect your data?
How to transfer data between 2 Google Drive accounts
6 Data Collecting Apps You Need to Delete for Better Privacy
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