Countif formula - percentage

[godonlyknows]

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

 

[daddylonglegs]

Assuming your data range is A1:A100 try

=COUNTIF(A1:A100,"good")/MAX(1,COUNTA(A1:A100))

format as percentage

 

[JE McGimpsey]

One way:

=COUNTIF(A:A,"Good")/COUNTA(A:A)

format the cell as a percentage.

godonlyknows

 

[godonlyknows]

Assuming your data range is A1:A100 try

=COUNTIF(A1:A100,"good")/MAX(1,COUNTA(A1:A100))

format as percentage

I think that's it. Thank you very much.