| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
% 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
% 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
% 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
