cells contain letters need % in total cell

T

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
 
T

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
 
T

teeitup

Nevermind.

After closing and opening the spreadsheet, the formula worked.

???

Thanks very much for your help.

Later
 
Top