If then add 1?

[bambamnwt]

I need to create a formula to add to a total field if Yes is entered in another.
Example:
If y is entered in A1 then Total of C1 increases by 1.

Objective is to record number of games played by individual players throughout the season.

Therefore as I see it:
If A1="y" then c1 + 1, else no change to c1.

Hope this makes some kind of sense. How do I write this using the formula reference cell value in the calculation.
I can't get it to work for me.

Thank you so much.

[davesexcel]

Place the macro in a worksheet module
Each time a y is placed in A1 the cell C1 will increase by 1


Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = ("$A$1") Then
If Target = "y" Then
Range("C1").Value = Range("C1").Value + 1
End If
End If
End Sub