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. Select any color here, we have selected YELLOW, 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.
