CountIfs by Color - Is this possible?

Hello,

color is not data. When you manually set a cell color to give it a certain status, then that logic is inside your head, not in the Excel spreadsheet. There is no formula or function to extract the logic from your head.

A better way is to use another cell to enter the status as a word, a code, or a number. Then you can use conditional formatting to set the cell color based on that status cell. In addition to that, you can now easily use functions like Sumif, Sumifs, Countif or Countifs to analyse the data based on the value in the status column. Or quickly create a pivot table with just a few clicks and no formulas at all.