=(rows(A1:A7)-countif(A1:A7,"NA"))/rows(A1:A7)

Assumes you want to exclude ONLY the NAs. But it's not going to be 80% in
your example. 5/7 is NOT 80%

"Ryan" wrote:

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