Your reference cells in row 3 to pick up the colorindex are conditionally formatted, which is not picked up by colorindex. And CF will change the color without triggering a re-calc, so that self-referential technique is just a bad idea.

If you are using CF to find the cells to sum, then you should use a formula that replicates the CF rule. If you are manually coloring the cells, then instead of referencing a cell that uses CF, use a cell that is also manually formatted for the color of interest.