=COUNTIF(A:A,"Y")

Nevermind. Excel Help is a wonderful thing!

Thanks again,
Brian