Expressing percentage

[Wayprof]

Hi guys,

If I have a very long column list of 2 subject types, for example 'Apples' and 'Oranges' (with each line containing just one of these words) what can be the formula to express one against the other as a percentage?

Such as - there are 86% of Oranges...


Thanks in advance for the help

[XOR LX]

Hi,

Perhaps, assuming your range is A1:A10:

=COUNTIF(A1:A10,"Oranges")/ROWS(A1:A10)

Format cell as percentage.

Edit: I assume you're mistaken when you write: "one against the other as a percentage..."?

Regards