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!