Shulou(Shulou.com)06/01 Report--

Excel is very common in our daily office. Most of the time, when we record reports, important content will be marked with different colors. What method should we use when summing these different colors? Does it have to be calculated one by one? In fact, it is not necessary, the following methods will be shared with you!

As shown in the following figure, you need to sum the numbers of column A, B, and C, D, in column G according to the specified color.

Specific operation method

1. Red font. Press Ctrl+F to bring up the search dialog box, click the option on the lower right, select the format in the search content-select the format from the cell, click a red font cell, you can see the preview, then click find all, press Ctrl+A to check all the red fonts found, and then close the find dialog box. Click the Formula tab-define the name, which is defined as [red]

two。 Blue font. Press Ctrl+F to bring up the search dialog box, click format-clear search format (clear the format of the red font) select the format from the cell, click a blue font cell, then click find all, press Ctrl+A to check all the red fonts found, and then close the find dialog box. Click the Formula tab-define the name, which is defined as [blue]

3. Orange font. As before, clear the lookup format and reselect the cell format, defining the name as [orange]

Specify the sum of colors, enter the formula = SUM (red) in the G2 cell to sum the red numbers.

For the specified color count, enter the formula in G2 cell: = COUNT (red) to calculate the number of red numbers, as well as the average, maximum, minimum, and so on.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.