Issue with Percentage

[CMD92]

Hi there, I’m looking for a simple formula to use so I can see what percentage of my data is a certain number/letter.
For example:

N
N
Y
Y
Y

In the box below I would like it to show what percentage of my data is Y compared to N. For the data above I know it would be Y=60% of the total data. I’ve tried many formula’s but none seem to do what I require.

Thanks in advance!

[mikekaganski]

Your example is unclear.

1. Are “N N Y Y Y” five distinct cells, or one cell with five characters separated by a space, or a cell with 5 characters adjacent (and you added spaces for clarity)?
2. You write “what percentage of my data is Y compared to N” (which would be 150%), and immediately below write “60% of the total data”. Looks like you describe your task carelessly - be aware that that would result in uncertainty to whoever tries to help.
3. “I’ve tried many formula’s but none seem to do what I require” - so what had you tried? Always mention what you tried so far.

Better attach a sample spreadsheet, so that others don’t need to guess.

[Lupp]

(Did no longer wait for an explanation.)
Example for how to get a ratio based on my assumptions concerning the details.

[LeroyG]

Given data in A1:A5, =COUNTIF(A1:A5;"Y")/COUNTA(A1:A5)*100, where Y is the text/number to be evaluated against the total.

LibreOffice Help on COUNTA and COUNTIF.