Greetings!

I am trying to convert my COUNTIF number to a percentage. So, for example

=COUNTA(H6:H15)-COUNTIF(H6:H15,"Y"), the result is 7, I want it to display 7%
=COUNTA(H16:H27)-COUNTIF(H16:H27,"Y"), the result is 10...I want it to display 10%
and so on

However, every time I click on "Format Cells", "Percentage", it multiplis the cell values by 100 (so, 700%, 1000%, etc).

Any thoughts?

Thanks!