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.