S Sheeloo May 18, 2009 #2 =COUNTIF(D613,"Y") will give you the count of cells having "Y" as their value...