| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
help with percentage of yes or no's
I have a spread sheet where a question is answered with a yes or no how
do i convert that into a percentage for the entire row? a1 complete? a2 yes a3 no a4 no a5 no a6 percent complete a7 25% does this make sense? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
help with percentage of yes or no's
|
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
help with percentage of yes or no's
In A7:
=COUNTIF(A2:A5,"Yes")/ROWS(A2:A5) that's one of several ways to do it, the COUNTIF() is the way to count "Yes" entries in the range, while ROWS() will give you a total count of the range whether they are Yes, No or empty. " wrote: I have a spread sheet where a question is answered with a yes or no how do i convert that into a percentage for the entire row? a1 complete? a2 yes a3 no a4 no a5 no a6 percent complete a7 25% does this make sense? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
help with percentage of yes or no's
wow thank you i really did not expect anyone to take the time to help.
at least not that fast! it worked perfectly thanks again.. JLatham wrote: In A7: =COUNTIF(A2:A5,"Yes")/ROWS(A2:A5) that's one of several ways to do it, the COUNTIF() is the way to count "Yes" entries in the range, while ROWS() will give you a total count of the range whether they are Yes, No or empty. " wrote: I have a spread sheet where a question is answered with a yes or no how do i convert that into a percentage for the entire row? a1 complete? a2 yes a3 no a4 no a5 no a6 percent complete a7 25% does this make sense? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
help with percentage of yes or no's
Glad to have helped, Dallman's solution would have worked also.
If you find help offered here actually helpful, people really appreciate you giving feed back using the [yes][no] buttons on their postings? " wrote: wow thank you i really did not expect anyone to take the time to help. at least not that fast! it worked perfectly thanks again.. JLatham wrote: In A7: =COUNTIF(A2:A5,"Yes")/ROWS(A2:A5) that's one of several ways to do it, the COUNTIF() is the way to count "Yes" entries in the range, while ROWS() will give you a total count of the range whether they are Yes, No or empty. " wrote: I have a spread sheet where a question is answered with a yes or no how do i convert that into a percentage for the entire row? a1 complete? a2 yes a3 no a4 no a5 no a6 percent complete a7 25% does this make sense? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
help with percentage of yes or no's
Since sschadel didn't post in the microsoft communities I am sure he has no
idea what your are talking about with respect to yes and no buttons. This should be visible to you in the communities interface. -- regards, Tom Ogilvy "JLatham" wrote in message ... Glad to have helped, Dallman's solution would have worked also. If you find help offered here actually helpful, people really appreciate you giving feed back using the [yes][no] buttons on their postings? " wrote: wow thank you i really did not expect anyone to take the time to help. at least not that fast! it worked perfectly thanks again.. JLatham wrote: In A7: =COUNTIF(A2:A5,"Yes")/ROWS(A2:A5) that's one of several ways to do it, the COUNTIF() is the way to count "Yes" entries in the range, while ROWS() will give you a total count of the range whether they are Yes, No or empty. " wrote: I have a spread sheet where a question is answered with a yes or no how do i convert that into a percentage for the entire row? a1 complete? a2 yes a3 no a4 no a5 no a6 percent complete a7 25% does this make sense? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
help with percentage of yes or no's
My lack of attention to detail showing again!
And apologies to sschadel if I seemed rude. Did not mean to be. The thanks he gave was sufficient, I just kind of figure is someone sees the green check here at the Microsoft place, then they can pass it by and help another deserving soul. I'll try to pay more attention in the future. And again, sincere apologies to sschadel. JLatham "Tom Ogilvy" wrote: Since sschadel didn't post in the microsoft communities I am sure he has no idea what your are talking about with respect to yes and no buttons. This should be visible to you in the communities interface. -- regards, Tom Ogilvy "JLatham" wrote in message ... Glad to have helped, Dallman's solution would have worked also. If you find help offered here actually helpful, people really appreciate you giving feed back using the [yes][no] buttons on their postings? " wrote: wow thank you i really did not expect anyone to take the time to help. at least not that fast! it worked perfectly thanks again.. JLatham wrote: In A7: =COUNTIF(A2:A5,"Yes")/ROWS(A2:A5) that's one of several ways to do it, the COUNTIF() is the way to count "Yes" entries in the range, while ROWS() will give you a total count of the range whether they are Yes, No or empty. " wrote: I have a spread sheet where a question is answered with a yes or no how do i convert that into a percentage for the entire row? a1 complete? a2 yes a3 no a4 no a5 no a6 percent complete a7 25% does this make sense? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
| Displaying percentage in ranges in pivot table | Excel Worksheet Functions | |||
| Percentage difference calc that knows the largest figure | Excel Discussion (Misc queries) | |||
| Percentage Calculation | Excel Worksheet Functions | |||
| Formatting percentage signs in Excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
