Countif formula - percentage

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

Assuming your data range is A1:A100 try

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

format as percentage

One way:

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

format the cell as a percentage.

In article <godonlyknows.22yq1a_1139489400.8201@excelforum-nospam.com>,
godonlyknows
<godonlyknows.22yq1a_1139489400.8201@excelforum-nospam.com> wrote:

> 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

Originally Posted by daddylonglegs

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.