How to count and sum "Condtional formatting" cells by color ?

[coniconi]

Hello !

Is there any functional code (or other approach) which can count and sum all cells by "Conditional formatted" colors, on one sheet, and that the generated result is linked through common formulas? That can be updated/refreshed/run code during the work process as a complete overview of the all matrix colors.

The sample file I'm dealing with is here http://ge.tt/9dwKutm2

I installed few add-ins for counting "Conditional formatted" cells but all are generating an instant (one-time) numeric result by activating that command - Kutools and Ablebits.

Also, I tried a code which gives an instant counting of single picked color without a total sum of all other colors -in my case 12 colors in a 52x24 matrix. ("How to use the code to count colored cells and sum their values" - https://www.ablebits.com/office-addi...y-color-excel/ )

Any help is appreciated. Thanks !

 

[C with no eyes]

Is it not possible to apply the same formula used for the conditional formatting to the countifs sumifs?

 

[coniconi]

Hello, I'm not sure for that kind of formula, because final matrix is empty, without any numerical (or textual) data and are defined only by the background colors. The colors I need to count and sum.
If you perhaps have a solution your are welcome post here the formula or to edit the sample file I attached.
Thanks!