How do I get a percentage of D6:d13 with the letter "Y" in cell E5
S Sheeloo May 18, 2009 #2 =COUNTIF(D613,"Y") will give you the count of cells having "Y" as their value...