Excel sum by color, excel sum by font color

You can't sum by color, but you can first classify the values of the colors and then sum them.

Microsoft Office is an office software suite developed by Microsoft Corporation, which can run on Microsoft Windows, Windows Phone, Mac family, iOS and Android. Like other office applications, it includes federated servers and internet-based services. From 2007 versions of Office are called "Office System" instead of "Office Suite", reflecting the fact that they include servers.

Office was originally a promotional name that appeared in the early 1990s to refer to a collection of software that had previously been sold separately. At that time, the main promotion focus was that buying a collection would save a lot of money compared to buying it individually.

The original Office version included Word, Excel, and PowerPoint. The "Professional Edition" included Microsoft Access, which did not exist at the time. Over time, Office applications have gradually integrated, sharing features such as:

Spelling and grammar checking, OLE data integration, and VBA scripting language. Microsoft extends Office as a development platform that can be used with third-party software through a dedicated store**.

Office is often the standard for making document files, and there are some features that other products don't have, but other products also have features that Office lacks. Since Microsoft 2007 Office System, there has been a very different user interface than previous versions, which is called the ribbon interface and is used in Microsoft Office 2010, Microsoft Office 2013 and Microsoft Office 2016.

Teach you a lookup method to sum by color.

After entering the data in excel, it is often necessary to sum, but sometimes there is a need to sum according to the font color. The following is the method of summing excel by font color that I bring to you for your reference.

How to sum by font color in excel:

Sum by color Step 1: Start Excel2010, open the data, we see there are some yellow cells, press the Ctrl+F keys on the keyboard, open the find dialog box, click the option button stool slag.

Sum by colorStep 3: pop up the cell formatting interface, we are in the Fill tab, select yellow, OK.

Sum by color Step 4: Now the search content is the yellow cell, click the Find All option.

Sum by colorStep 5: When the search is complete, click the first item of the search result and hold down the shift key.

Click on the last item, so that all the search results can be selected, and the Zaoqin quiet interface will be closed.

Sum by color Step 6: Then click the menu bar - Formula - Define name, pop up the new name dialog box, the name we enter the yellow cell, OK.

Sum by color Step 7: In this way, the selected cell is named as a yellow cell, and we directly enter =sum (yellow cell) in the specified cell.

Sales statistics for different flower varieties, all sales greater than 500 are highlighted in red font. Next, we're going to sum all the sales in red font in cell i1.

Procedure. 1. Press Ctrl+F keys at the same time to bring up the Find and Replace dialog box, click the inverted triangle on the right side of the Format button under the Find tab, and select the Format command in the drop-down list.

2. In the pop-up Find Format dialog box, click the Select Format from Cells button below, then the mouse will change to an eyedropper shape, and click any cell with red font.

3. Go back to the Find and Replace dialog box, click the Find All button, that is, all the cells with red font are displayed below the dialog box.

4. Press Ctrl+A to select all the found red font cells.

5. Click the Define Name button in the Name function group of the Formula tab, and the New Name dialog box pops up, and enter it in the Name box"Red font", click the OK button.

6. Select cell i1 and enter the formula: =sum (red font), then the total value of all red font sales will be returned: 11932.

1. Now ask for the sum of the data on the yellow background.

2. First of all, press the shortcut key Ctrl+F to pop up the [Find and Replace] dialog box, pull down the [Format] menu, and [Select Format from Cell].

3. Click on a cell with a yellow background, and then click [Find All] to find all the data with a yellow background.

4. Select all the data in the box, and then click [Close].

5. Click [Formula] - Define Name to define a name for the selected data;

6. In the pop-up [New Name] dialog box, change the name to [Yellow Background] <>

7. Click [Formula] -- Auto Sum -- Sum] -- Sum;

8. Enter [=sum (yellow background)] in the column of the formula to get the sum in the yellow background.

Hello! To calculate the sum of colored cells, you should first find out the cells and customize the name. Here's how;