Countif formula - percentage

G

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
 
D

daddylonglegs

Assuming your data range is A1:A100 try

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

format as percentage
 
J

JE McGimpsey

One way:

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

format the cell as a percentage.

godonlyknows
 
G

godonlyknows

daddylonglegs said:
Assuming your data range is A1:A100 try

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

format as percentage
Click to expand...

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