Select any color here, we have selected YELLOW, as shown below. Now go to the top filter drop-down of the same column and select any required colored to get summed up from the Filter by Color option. Now from the drop menu of the total sum, select the Sum option as shown below.īy this, we enable the table to sum the filtered data as per colored cells. Once we do that, we will get the sum of cells at the bottom end of the column with a drop-down menu. Now Check tick the Total Row option from the Table Style Options.
And another menu will get added with the name Design in the menu bar. Once we do that, selected cells will get converted into the table form. Now click on Ok from the Create Table box. This will enable the selected cells to get converted into table format. Now copy the column’s cells with numbers and paste them into a separate sheet or in the same sheet in a different location. For this, we will consider the same data as shown in example-1. There is another way to sum the numbers by their colors. We can check the correctness of the applied SUBTOTAL formula by filtering the different colors as well. Once we do that, we will get the Output cell filtered sum as 190, as shown below. Go to Filter by Color from the drop-down menu of it. Now apply the filter in the top row by pressing Ctrl + Shift +L. And for reference1, select the complete range of column C, which we need to total as shown below.
0 kommentar(er)
