Ask Your Question

Issue with Percentage

asked 2020-02-15 03:33:44 +0100

CMD92 gravatar image

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:


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!

edit retag flag offensive close merge delete



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.

Mike Kaganski gravatar imageMike Kaganski ( 2020-02-15 08:38:42 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-02-15 13:12:09 +0100

Lupp gravatar image

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

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-02-15 03:33:44 +0100

Seen: 28 times

Last updated: Feb 15