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
 
Do you mean this

=COUNTIF($B$1:B1,B1)/COUNTA($B$1:B1)

formatted as percentage?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

percentages 1
Help, I need a formula for work. 2
Yes / Yes + N Responses for percentage 4
Calculations in Group Footer 7
Need help using data from multiple worksheets to create a Summaryreport 1
Need help to create a macro 2
Counting Rows 6
Conditional popup 4

Back
Top