ExcelBanter - % yes

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - % yes (https://www.excelbanter.com/excel-discussion-misc-queries/57358-%25-yes.html)

joe

% yes

i have a column wiv loads of values either yes or no, i want to know the
percentage of yes's in the column

JE McGimpsey

% yes

One way:

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

format as a percent.

In article ,
joe wrote:

i have a column wiv loads of values either yes or no, i want to know the
percentage of yes's in the column

Ron Coderre

% yes

Try this:
=COUNTIF(A1:A10,"yes")/COUNTA(A1:A10)
Format as Percent

Does that help?

***********
Regards,
Ron

"joe" wrote:

i have a column wiv loads of values either yes or no, i want to know the
percentage of yes's in the column

All times are GMT +1. The time now is 12:43 PM.