=COUNTIF(A1:A7,"Y")/COUNTIF(A1:A7,"<NA")
and format as percentage

"Ryan" wrote in message
...
Hello, I hope someone can help me. I am working on a spreadsheet in which
I
want to average a column of cells with the letter "Y", but not average the
cells (in the same range) with an "NA". I would also like the average
total
be displayed as a percentage.

For Example:
A B C
1 Y
2 NA
3 Y
4 Y
5
6 NA
7 Y

In this example I want to average A1:A7, but return a percentage of the
"Y's" and blanks and not include the "NA's." I know the answer will be
80%
in this example, but I don't know how to express that in a formula.

Thanks in advance,
Ryan