Supposing you have a worksheet containing a range of cells as shown in the below screenshot, and you want to apply calculations (count, sum, etc.) to the range based on their background or shading color. You can do it as follows.

1. Please select the range that you want to apply calculations based on their background / shading color, and apply the Count by Color utility (Click Kutools Plus > Count by Color).

2. In the opening Count by Color dialog,

(1) Click the Color method box and specify one of options from the drop down list;

(2) Click the Count type box and specify the Background from the drop down list.

A: Count: it will calculate how many cells with specific cell color in the range. B: Sum: it will add all the number in the cells with specific cell color in the range. C: Average: it will return the average of the cells with specific cell color in the range. D: Max: displaying the Max value of the cells with specific cell color in the range. E: Min: displaying the Min value of the cells with specific cell color in the range.

Tips:

There are three options in the drop down list of Color method: Standard formatting, Conditional formatting, and Standard and Conditional formatting.

If you need to calculate cells by fill/background color which are formatted with Home > Fill Color, please select Standard formatting; if you need to calculate cells by fill/background color which are formatted by Conditional Formatting, please select Conditional formatting; if calculating all cells by fill/background color, please select the Standard and Conditional formatting.

3. If you want to generate the report in a new workbook, please click Generate report button. And you will see the report in the new workbook as follows:

For example, you have a range of cells formatted by different font colors as below screen shot shown, and you want to calculate (count, sum, average, or others) the cells by their font colors, you can apply the Count by Color utility as following:

1. Select the range where you will calculate cells by font colors, and apply the Count by Color utility (Click Kutools Plus > Count by Color).

2. In the opening Count by Color dialog box:

(1) Click the Color method box and specify one of options from the drop down list based on your needs, such as Standard and Conditional formatting;

(2) Click the Count type box, and specify Font from the drop down list.

3. If you want to generate the report in a new workbook, please click the Generate report button. Then you will see the report in a new workbook as following screen shot shown: