Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
help with pervcentages
Walker YES
at he end of the line I need to show yes and no in percentages, and as I add additional clients this percentage changes Thanks in advance Cook YES Vailes NO Coleman YES Correa YES Leavitt NO Branch YES Forbes NO Walrath NO Bryant YES |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
help with pervcentages
Do you mean this
=COUNTIF($B$1:B1,B1)/COUNTA($B$1:B1) formatted as percentage? -- __________________________________ HTH Bob "Edgar G" wrote in message ... Walker YES at he end of the line I need to show yes and no in percentages, and as I add additional clients this percentage changes Thanks in advance Cook YES Vailes NO Coleman YES Correa YES Leavitt NO Branch YES Forbes NO Walrath NO Bryant YES |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
help with pervcentages
This will give you the percentage of "YES" in the range of B1:B100
=COUNTIF(B1:B100,"yes")/COUNTA(B1:B100) Make the range large enough to accomodate new entries. Gord Dibben MS Excel MVP On Sun, 5 Apr 2009 11:16:01 -0700, Edgar G wrote: Walker YES at he end of the line I need to show yes and no in percentages, and as I add additional clients this percentage changes Thanks in advance Cook YES Vailes NO Coleman YES Correa YES Leavitt NO Branch YES Forbes NO Walrath NO Bryant YES |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|