Excel Formula Show Percentage

[dad0519]

I'm trying to create a formula that gives the result of the number of cells in a row that contain text. For example if I have four cells in a row and three contain text the result would be 75%, if I have seven cells in a row and four have text the result would be 57%.

This is what I have so far... =COUNTA(B9:H9)/COUNTA(B9:H9)

[Salmon Trout]

=COUNTA(B9:H9)/COLUMNS(B9:H9)   Format cell as percentage; select number of decimal places.