In the Excel menu choose: DOSE EDITING » Format » Count by Color
Quickly Calculate Cells Value Based On Cell Font/Background Or /Shading Color In Excel
There are many formulas to perform data calculation in Excel. But if you want to count or sum cells by their fill or /background color or font color, and do other calculations with a range of cells based on a specified background / shading color or font color, there is no such formula for you to do so in Excel. But Dose for Excel's Count by Color utility can quickly apply calculations to cells based on cell color and generate a report in a new worksheet.