I have a sheet, with names and dates on.

Date Name
04/04/09 John
09/04/09 Phil
15/04/09 John
20/04/09 Phil
22/04/09 John
01/05/09 John

All i want is a formula to total up how many John's there are in the
spreadsheet in a formula, is it possible?.