Thanks, I was trying to use SUMIF, but it was too clunky. This is elegant.

"Elkar" wrote:

To count the "Y"'s use this formula:

=COUNTIF(A1:A30,"Y")

To count the nonblanks:

=COUNTA(A1:A30)

And, to combine the two:

=COUNTIF(A1:A30,"Y")/COUNTA(A1:A30)

HTH,
Elkar


"lia" wrote:

Out of 30 possible entries, I can have either y, n or blank. I want to
equate the sum of the "Y" and divide by the total number of y+n (not blank)
entries. Any ideas?