Excel offers plenty of functions, but sadly, none of them can be used directly to calculate the count of color-coded cells. Also, there’s no built-in way (whatsoever) to do so in Excel.

Counting records or values in Microsoft Excel is easy. Counting individual cells by their fill color definitely isn't. Using an old function and a matrix tames the problem.

Launch Excel and open one of your documents. Locate the status bar at the bottom of the window. Right-click that status bar to display a list of options. Click the "Count" option to place a ...

Or you might want a count by colors. In this article, I’ll show you a simple way to evaluate values by the cell’s fill color using Excel’s built-in filtering feature.