| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
