To make the data stand out more in Excel, we always format the cells with a filling color or font color. Counting or summing cells based on the color of the background or font is also necessary occasionally. In other words, calculating sum and count and average and maximum and minimum of the cells that share the same color. Regretfully, we are unable to complete this task in Excel directly. However, Dose for Excel’s Count by Color will help to quickly and simply solve this issue.
- Sum and count by standard formatting background color
- Sum and count by conditional formatting background color
- Sum and count by both standard and conditional formatting background color
- Sum and count by standard formatting font color
- Sum and count by conditional formatting font color
- Sum and count by both standard and conditional formatting font color
- Generate a report of colors and their sum and count and others calculations
Click DOSE » Format » Count by Color
![Sum And Count Cells By Color In Excel](https://zbrainsoft.com/wp-content/uploads/2024/01/3-3.png)
Sum and count by standard formatting background color
Please follow these steps if you want to count or sum the number of cells by a specific filled background color:
- Select range of cells that you want to count and sum its cells.
![Sum and count by standard formatting background color](https://zbrainsoft.com/wp-content/uploads/2024/01/4-2.png)
- Then select “Standard Formatting” from the “Color method” drop down list and select “Background” from the “Count type” drop down list. Then click Apply.
![Sum and count by standard formatting background color](https://zbrainsoft.com/wp-content/uploads/2024/01/5-1.png)
Sum and count by conditional formatting background color
Please follow these steps if you want to count or sum the number of cells by a specific conditional formatting background color:
- Select range of cells that you want to count and sum its cells.
![Sum and count by conditional formatting background color](https://zbrainsoft.com/wp-content/uploads/2024/01/4-2.png)
- Then select “Conditional Formatting” from the “Color method” drop down list and select “Background” from the “Count type” drop down list. Then click Apply.
![Sum and count by conditional formatting background color](https://zbrainsoft.com/wp-content/uploads/2024/01/6-5.png)
Sum and count by both standard and conditional formatting background color
Please follow these steps if you want to count or sum the number of cells by a specific standard and conditional formatting background color:
- Select range of cells that you want to count and sum its cells.
![Sum and count by both standard and conditional formatting background color](https://zbrainsoft.com/wp-content/uploads/2024/01/4-2.png)
- Then select “Standard and Conditional formatting” from the “Color method” drop down list and select “Background” from the “Count type” drop down list. Then click Apply.
![Sum and count by both standard and conditional formatting background color](https://zbrainsoft.com/wp-content/uploads/2024/01/7-1.png)
Sum and count by standard formatting font color
Please follow these steps if you want to count or sum the number of cells by a specific standard formatting font color:
- Select range of cells that you want to count and sum its cells.
![Sum and count by standard formatting font color](https://zbrainsoft.com/wp-content/uploads/2024/01/8.png)
- Then select “Standard formatting” from the “Color method” drop down list and select “Font” from the “Count type” drop down list. Then click Apply.
![Sum and count by standard formatting font color](https://zbrainsoft.com/wp-content/uploads/2024/01/9-2.png)
Sum and count by conditional formatting font color
Please follow these steps if you want to count or sum the number of cells by a specific conditional formatting font color:
- Select range of cells that you want to count and sum its cells.
![Sum and count by conditional formatting font color](https://zbrainsoft.com/wp-content/uploads/2024/01/8.png)
- Then select “Conditional formatting” from the “Color method” drop down list and select “Font” from the “Count type” drop down list. Then click Apply.
![Sum and count by conditional formatting font color](https://zbrainsoft.com/wp-content/uploads/2024/01/10-1.png)
Sum and count by both standard and conditional formatting font color
Please follow these steps if you want to count or sum the number of cells by a specific standard and conditional formatting font color:
- Select range of cells that you want to count and sum its cells.
![Sum and count by both standard and conditional formatting font color](https://zbrainsoft.com/wp-content/uploads/2024/01/8.png)
- Then select “Standard and Conditional formatting” from the “Color method” drop down list and select “Font” from the “Count type” drop down list. Then click Apply.
![Sum and count by both standard and conditional formatting font color](https://zbrainsoft.com/wp-content/uploads/2024/01/11.png)
Generate a report of colors and their sum and count and others calculations
Please follow these steps if you want to generate a report of colors and the calculations in new Excel sheet to easily manipulate:
- Click on “Report” button and a report will be generated in a new worksheet.
![Sum And Count Cells By Color In Excel](https://zbrainsoft.com/wp-content/uploads/2024/01/12-1.png)
Demo: Sum and count cells by color in Excel
More Features:
How to Remove Leading Or Trailing Or Extra Spaces In Excel
Remove Leading Or Trailing Or Extra Spaces From Excel Cells You can remove leading spaces,…
Excel Backup Settings
Auto Backup Excel Workbooks Save time by auto backup your Excel files automatically once the…
Excel Hyperlinks Sheet Names
Convert All Your Worksheets into Hyperlinks in One Worksheet Extract all sheets names as hyperlinks…
How To Reverse Text Or Words In Excel
Reverse Text String Order In Excel Reverse any text the way you want, reverse all…
Compare Lists in Excel
Compare Lists in Excel If you ever want to compare lists by looking up for…
Excel Reading Layout View
Excel Reading Layout If you have a lot of data at your Excel sheet, then…