how to sum a column in excel based on another column

Collapsing & Expanding Columns After Column Grouping The four outline bars you can observe at the top represent different data organisation levels. Once the grouping of the above-mentioned monthly columns is done, you can observe that the columns are grouped perfectly in a dataset. Go to the Data tab in the Home ribbon, and it will open a toolbar below the ribbon, then click on the group option under the outline section now you can observe in a data, the columns are grouped perfectly.Ī similar procedure is applied or followed for the month of Apr, May, Jun & Jul, Aug, Sep & Oct, Nov, Dec columns. Initially, I need to select the column which I want to group it now, let’s select the months (i.e. I don’t want all the monthly sales data to be displayed I want only quarterly & yearly sales data to be displayed it can be done through multiple grouping of column options. Here the data is structured and does not contain any blank cells, hidden rows, or columns. In the below-mentioned example, the Table contains product monthly sales data from Jan to Dec month, and it is also represented in quarterly & yearly sales. Now, you can observe data bars & “+” buttons and “-” buttons disappear in the excel sheet once the ungroup option is selected.Įxample #2 – Multiple Grouping of Columns for Sales Data in Excel On the Data tab, in the Outline group, click on Ungroup command. the columns which you have previously grouped). Select the columns you wish to ungroup (i.e.

it is called a state, 1st option is called a hidden state (if you click on it, it will hide B, C, D, E Columns) whereas 2nd option is called unhidden state, it will expand those hidden columns, I.E. You can press the “-” buttons in the margin to collapse the columns (B, C, D, E Columns completely disappears) or in case If you want to expand them again, press the “+” buttons in the margin (B, C, D, E Columns appears)Īnother way to access data is the use of 1 or 2 options on the left side of the worksheet, i.e.

How to Collapse & Expand Columns After Column Grouping

How to sum a column in excel based on another column