| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
In Over My Head - Multiple Column Percentages
Can I get a percent ratio from multiple columns that uses letters or
characters? For example 4 columns with random Yes or No answers, 3 yes, 1 no, should show in Column E 75% in favor of Yes. There are also similar columns with the + and - signs instead of a word or numbers. Can these symbols be calculated? -- Thanks Cyber Gardener |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In Over My Head - Multiple Column Percentages
Hi!
Try this: For % of Yes: =COUNTIF(A1:D1,"yes")/4 Format the cell as PERCENTAGE You can follow the same example for "no" or "+" or "-". Biff "cybergardener" wrote in message ... Can I get a percent ratio from multiple columns that uses letters or characters? For example 4 columns with random Yes or No answers, 3 yes, 1 no, should show in Column E 75% in favor of Yes. There are also similar columns with the + and - signs instead of a word or numbers. Can these symbols be calculated? -- Thanks Cyber Gardener |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In Over My Head - Multiple Column Percentages
Thank you for the Great Answer, it made my day.
-- Thanks Cyber Gardener "Biff" wrote: Hi! Try this: For % of Yes: =COUNTIF(A1:D1,"yes")/4 Format the cell as PERCENTAGE You can follow the same example for "no" or "+" or "-". Biff "cybergardener" wrote in message ... Can I get a percent ratio from multiple columns that uses letters or characters? For example 4 columns with random Yes or No answers, 3 yes, 1 no, should show in Column E 75% in favor of Yes. There are also similar columns with the + and - signs instead of a word or numbers. Can these symbols be calculated? -- Thanks Cyber Gardener |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In Over My Head - Multiple Column Percentages
You're welcome!
Biff "cybergardener" wrote in message ... Thank you for the Great Answer, it made my day. -- Thanks Cyber Gardener "Biff" wrote: Hi! Try this: For % of Yes: =COUNTIF(A1:D1,"yes")/4 Format the cell as PERCENTAGE You can follow the same example for "no" or "+" or "-". Biff "cybergardener" wrote in message ... Can I get a percent ratio from multiple columns that uses letters or characters? For example 4 columns with random Yes or No answers, 3 yes, 1 no, should show in Column E 75% in favor of Yes. There are also similar columns with the + and - signs instead of a word or numbers. Can these symbols be calculated? -- Thanks Cyber Gardener |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In Over My Head - Multiple Column Percentages
Start by checking out the countif function. For example,
=countif(a2:d2,"Yes"). You may need to calculate ratios of multiple countifs. Ex: =countif(a2:d2,"Yes") / (countif(a2:d2,"Yes")+countif(a2:d2,"No")). "cybergardener" wrote: Can I get a percent ratio from multiple columns that uses letters or characters? For example 4 columns with random Yes or No answers, 3 yes, 1 no, should show in Column E 75% in favor of Yes. There are also similar columns with the + and - signs instead of a word or numbers. Can these symbols be calculated? -- Thanks Cyber Gardener |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In Over My Head - Multiple Column Percentages
Works great. Thanks, you are a life saver.
-- Thanks Cyber Gardener "bpeltzer" wrote: Start by checking out the countif function. For example, =countif(a2:d2,"Yes"). You may need to calculate ratios of multiple countifs. Ex: =countif(a2:d2,"Yes") / (countif(a2:d2,"Yes")+countif(a2:d2,"No")). "cybergardener" wrote: Can I get a percent ratio from multiple columns that uses letters or characters? For example 4 columns with random Yes or No answers, 3 yes, 1 no, should show in Column E 75% in favor of Yes. There are also similar columns with the + and - signs instead of a word or numbers. Can these symbols be calculated? -- Thanks Cyber Gardener |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In Over My Head - Multiple Column Percentages
One more thing please for n/a. How do I calculate the formula if a n/a is
entered and should be counted as a yes. -- Thanks Cyber Gardener "bpeltzer" wrote: Start by checking out the countif function. For example, =countif(a2:d2,"Yes"). You may need to calculate ratios of multiple countifs. Ex: =countif(a2:d2,"Yes") / (countif(a2:d2,"Yes")+countif(a2:d2,"No")). "cybergardener" wrote: Can I get a percent ratio from multiple columns that uses letters or characters? For example 4 columns with random Yes or No answers, 3 yes, 1 no, should show in Column E 75% in favor of Yes. There are also similar columns with the + and - signs instead of a word or numbers. Can these symbols be calculated? -- Thanks Cyber Gardener |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In Over My Head - Multiple Column Percentages
=countif(e1:e20,"yes")/20
(E1:E20 has 20 cells) format as percentage. or =countif(e1:e20,"yes")/(countif(e1:e20,"yes")+countif(e1:e20,"no")) this is equivalent: =countif(e1:e20,"yes")/sum(countif(e1:e20,{"yes","no"})) cybergardener wrote: Can I get a percent ratio from multiple columns that uses letters or characters? For example 4 columns with random Yes or No answers, 3 yes, 1 no, should show in Column E 75% in favor of Yes. There are also similar columns with the + and - signs instead of a word or numbers. Can these symbols be calculated? -- Thanks Cyber Gardener -- Dave Peterson |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In Over My Head - Multiple Column Percentages
Hey Dave,
Works like a charm. Thanks so much for the help. -- Thanks Cyber Gardener "Dave Peterson" wrote: =countif(e1:e20,"yes")/20 (E1:E20 has 20 cells) format as percentage. or =countif(e1:e20,"yes")/(countif(e1:e20,"yes")+countif(e1:e20,"no")) this is equivalent: =countif(e1:e20,"yes")/sum(countif(e1:e20,{"yes","no"})) cybergardener wrote: Can I get a percent ratio from multiple columns that uses letters or characters? For example 4 columns with random Yes or No answers, 3 yes, 1 no, should show in Column E 75% in favor of Yes. There are also similar columns with the + and - signs instead of a word or numbers. Can these symbols be calculated? -- Thanks Cyber Gardener -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Multiple Functions In One Column | Excel Worksheet Functions | |||
| match and count words | Excel Worksheet Functions | |||
Hybrid Mode
