To sum the cells of a particular color in a Excel2013

In order to highlight some of the data in the Excel data table, we generally set the cell format, the most common is to distinguish between different colors. If you want to calculate the cell data for these specific colors, is there a quicker and more efficient way to do this? The following, small series to introduce a practical technique.

Operation Steps

To start Excel2013, to sum the yellow cells in the table, first click the Edit button under the Start tab-Find and select-to find.

Pop-up Lookup dialog box, we click the option directly.

A detailed lookup appears below, and the Format button is clicked.

Switch to fill label, select Yellow, click OK.

Click the Find All button, the search results appear, 7 cells are found, and hold down the SHIFT key to select the 7.

Close the Find dialog box and click on the Formula tab to define the name option.

Enter the name, the yellow cell, so that the cell you just selected is defined with a new name: Yellow cell, we directly enter formula =sum (yellow cell).

After the carriage return, get the result 3950, the sum of the yellow cell data in the table.