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.

How to Count the Number of Non-Blank Cells in Excel. Microsoft Excel allows you to crunch massive quantities of data easily through the use of functions.

Thankfully, Microsoft Excel's COUNTIF formula swoops in to save the day. It lets you count cells based on specific text or conditions, turning your spreadsheet chaos into organized data magic.