Hi,

I'm new here and I hope I'm posting in the right forum. I require help with a formula that has left me scratching my head for a couple of hours.

I have a column of data cells that lists 3 different options, for example:

option1 = Good
option2 = Ok
option3 = Bad

i need a formula that will count how many 'Good' entries there are and to work it out as a percentage of the total number of entries (all 3 options).

I hope that makes sense. If more info is required, please let me know.

Thanks for your time