Working out percentages % !?!

[samc80]

Hi All,

This may seem like a really simple Q to some, but I cannot work it out for the life of me so am asking the experts for help

Is there anway for me to set up a formula that will show the percentage of how many times I have entered a value in a cell.

E.g If I have a column populated with Yes or No. Can I ask Excel to tell me the percentage of how many times Yes been entered??

So if I have 5 Y's and 5 N's (yes I know this is very simple and the answer is 50% !!) can I put something in to tell me what the percentage out of the total number of entries entered is Yes??

Sorry if this is really stupid

Thanks,
Sam

 

[VoG]

Try like this - format the result cell as %

=COUNTIF(A1:A10,"Yes")/COUNTA(A1:A10)

 

[p45cal]

Excel Workbook
	K	L
51	Yes
52	Yes
53	Yes
54	No	57.89%
55	No	45.83%
56	No
57	No
58	Yes
59	Yes
60	Yes
61	Yes
62	No
63	No
64	No
65	Yes
66	Yes
67	No
68
69
70
71
72
73	Yes
74	Yes
Sheet

both cells fomatted as %.
The L54 formula gives the percentage of Yes v. No, ignoring any other cells in the range, be they empty or contain something else.
The L55 one gives the percentage of Yes in the whole range, counting anything none Yes as part of the equation.

…and I've just seen VoG's which will perhaps give a different result again being the percentage of Yes in the non-blank cells of the range. It all depends on what's in the range to be analysed.

 

[tc88]

Hi All,

This may seem like a really simple Q to some, but I cannot work it out for the life of me so am asking the experts for help

Is there anway for me to set up a formula that will show the percentage of how many times I have entered a value in a cell.

E.g If I have a column populated with Yes or No. Can I ask Excel to tell me the percentage of how many times Yes been entered??

So if I have 5 Y's and 5 N's (yes I know this is very simple and the answer is 50% !!) can I put something in to tell me what the percentage out of the total number of entries entered is Yes??

Sorry if this is really stupid

Thanks,
Sam

=COUNTIF(A1:A20,"YES")/COUNTA(A1:A20)

Where A1:A20 is your column with the Yes/No in it, then format as percentage.

 

[samc80]

Ahhhh thank you all SO much

Stars all of you.... !