You can then pick any function from the Show results for drop-down list to see the needed calculation results: The app will quickly perform all math operations on your data. The results will be displayed on the Count & Sum by Color pane grouped by color codes: Press the Calculate button to process the range:
Select the Font radio button to process the selected values by their text color.
Press the Background radio button to calculate by the color of cells. Now you can specify the color option by selecting the Background or Font radio button: It's also possible to click on the Select range button to pick the necessary area manually: Highlight the needed range in your table and you will see its address in the Select range field: You'll see the Count & Sum by Color pane open. If you need to sum or count all highlighted cells in Excel 2011, first open the worksheet with your data and run the Count & Sum by Color app by clicking on its name under the tab: If you are fond of using different color codes to highlight certain parts of data, this helpful app will show you Sum, Count, Average, Min or Max for the colored cells. Count & Sum by Color app will become your reliable assistant in adding or counting cell values grouped by colors.
