cells contain letters need % in total cell

[teeitup]

I have a range of cells in a row that are either "Y" or "N"
I want the "total" cell at the end of the row to display the percentag
of Y's.

Say I have 20 cells. 11 have Y's and 9 have N's. I need for the "tota
cell" at the end of the row to diplay 55%. The Y's and N's shoul
continue to display as letters.

Thanks

 

[Jack Schitt]

=COUNTIF(Range,"=Y")/(COUNTA(Range))

 

[Aladin Akyurek]

In case n(Y)/(n(Y)+n(N)) is desired...

=COUNTIF(Range,"Y")/SUM(COUNTIF(Range,{"Y","N"})

=COUNTIF(Range,"=Y")/(COUNTA(Range))

 

[teeitup]

Thank you for your replies.

I have entered the following string:

=COUNTIF(B8:T8,"Y")/SUM(COUNTIF(B8:T8,{"Y","N"}))

My result is "#NAME?" invalid name.

Both of the suggested formulas produce the same output.

Thanks

 

[teeitup]

Nevermind.

After closing and opening the spreadsheet, the formula worked.

???

Thanks very much for your help.

Later