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