Líon torthaí formáid choinníollach

I have an Excel with 65 columns and each column contains 55 lines with conditional formatted cells (with multiple formulas) that are fed by underlying pages.The conditional formatted cells show red, orange, yellow and green
Per column I want to show the total count per color.
Using Kutools I have to do it per column and it then creates a different page and I then have to enter the numbers manually.
Is there a way to show the totals per column per color automatically?