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

[coniconi]

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

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

Please Login or Register  to view this content.

123.JPG

My question is: Is there any functional code (or other aproach) 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/code run during the work process as a complete overview of colors of a matrix (and not by picking every color every time as I mentioned).

Thanks in advance!

[dominicb]

Good afternoon coniconi

There is no native way to count or sum cells that have been coloured using conditional formatting.
The only way to achieve what you want to do is count (or sum) the cells based on the conditions that you have used to format them - not try and identify the colour that conditional format has applied.

If you want further help on this, either attach a cut down version of your file, or post back giving the conditions you have used.

HTH

DominicB

[coniconi]

Thank you, Dominic for your time and your reply.

Generally, what I'm dealing with is a matrix sheet of 52x24 cells.
I have done on an easy way, which works - every column is manually copied from the first A column which generated first results and colors of "Conditional formatted" cells, which are all linked to the Database sheet.
I have used the macro (installed) to pick and get the sum of every color. I have used also add-ins Kutools and Ablebits, but all are "one time result".

What I'm looking, as previously mentioned, is there any way to make and "dynamic" sum results using basic or advanced formulas/macros.

I have attached a sample of the matrix I'm currently dealing with. http://ge.tt/9dwKutm2
Thank you in advance.