Count Cells By Color In Excel

Calculate count, sum, average, max and min for cells values according to the cells color or font color. Dose for Excel‘s Count by Color utility can easily do this with one click on huge Excel sheets.

Click DOSE » Format » Count by Color


  1. Select a range of cells.
  2. And then click Apply. The utility will calculate values of based on their background or font color or even shading color. There is no formula in Excel that performs this task, Dose for Excel’s count by color utility can apply the calculations based on cells color and ability to generate a report in a new Excel worksheet. See screenshots:

More Features:

Excel Random Generator

Generate Random Data (Numbers, Date, String, etc…) Sometimes you want to generate some random data…

Excel Clean Data

Clean Data In Excel Clean data in huge Excel sheets could take long time doing…

Scroll to Top