Excel formula building

I am trying to create an excel formula that will increase a number in a cell by 1 when a specific number is entered in cell a14. In my worksheet I have 10 colours listed, each with a number from 1 to 10. What I am trying to do is be able to type a number from 1 to 10 in cell a14 and for it to then count up by 1 in the cell next to the corresponding colour, which will be cells c3 to c12. We ran a vote at work and I need to be able to log how many votes each colour received. The link below is to a screenshot of my worksheet.

Any help with this will be greatly received.

Recent Questions...