help with pervcentages

  • Thread starter Thread starter Edgar G
  • Start date Start date
E

Edgar G

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
 
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
 
Back
Top