Do you want a ration or a percentage? Try this in F2 first:

="Ratio is "&COUNTIF(E2:E5,"Y")&" yes to "&COUNTIF(E2:E5,"N")&" no
responses"

Or you could try this:

=COUNTIF(E2:E5,"N")/COUNTA(E2:E5)

and format as percentage - should give you 25%.

Hope this helps.

Pete

Cindy wrote:

I have a spreadsheet where I need to create a formula that will show a ratio.

Example
E2 = Y
E3 = N
E4 = Y
E5 = Y
F2 needs to show the percentage of those 4 cells