Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
=COUNTIF(A2:A500,"yes")/COUNTA(A2:A500)
format result as percentage -- Regards, Peo Sjoblom "jpmurray22" wrote in message ... Is there a way for me to find out the percentage of "yes" answers in the following example. I know that there are 4 yes and 2 no, but is there a way to divide 4 by the total number of cells, for when my list becomes hundereds of cells long? yes no yes yes yes no 4 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
PERCENTAGES | Excel Worksheet Functions | |||
percentages | Excel Discussion (Misc queries) | |||
Percentages | Excel Discussion (Misc queries) | |||
percentages | Excel Discussion (Misc queries) | |||
count for percentages | Excel Worksheet Functions |