Counting the colored cells

So I have been searching posts and reading about a few versions of VBA code used to count cells based on their color. Every version I have used gives me a #NAME error on the =CountColor(range,color) formula used in the cell returning the sum. I'm not sure if it is being caused by the data entered in the cells because when I define the range to count it shows all of those values in the formula assistant window. To be completely honest, my brain is "vapor locked" at this moment and I would like someone to show it to me on this spreadsheet I am working on for a friend. I can learn once I see what works and compare it to how I got it wrong. Is anyone willing to assist? The count should happen per row and I have put the desired result in the column on the right of the spreadsheet. The punchline here is she is looking to count the number of yellow cells per row.

As the cells that are yellow are turned so because of specific rules, I'd recommend not going down the VBA route, but instead tweaking the conditional formatting and adding an extra 'Result' row.

It's difficult to explain as I can't upload a file from work, but if you add a new row in row 6, call it RESULTS, and then put the result in each cell in the row as it happens.

You can then use the following formula in column AS:
=SUMPRODUCT(--(C7:AQ7=C$6:AQ$6))

You can also then get rid of the individual conditional formatting on each column and replace it all with one rule to make the cell colouring all automatic, with the formula:
=C7=C$6