Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tallying
Hello. I have created a survey and need to tally the results. It's just a
basic survey that has around 50 questions with the selection of O-Outstanding, G-Good, A-Adequate, IN-Improvement Needed and NJ-No Basis for Judgement. I have received over 200 of these surveys and I would like to be able to click on a button and have it tally the results, is this possible in excel? I've tried everything I can think of but can't come up with anything. Thanks for your help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tallying
Yes, it's possible, so you haven't tried everything.
Posting a representative sample of your data would help. A lot depends on how it's organized. Also, telling us what you've tried would avoid expending effort that's not worthwhile. In the meantime, you could look at the Sumif/Countif functions and Pivot Tables. I suspect Pivot Tables will do exactly what you want, but they take some effort to learn. -- Regards, Fred "feenster" wrote in message ... Hello. I have created a survey and need to tally the results. It's just a basic survey that has around 50 questions with the selection of O-Outstanding, G-Good, A-Adequate, IN-Improvement Needed and NJ-No Basis for Judgement. I have received over 200 of these surveys and I would like to be able to click on a button and have it tally the results, is this possible in excel? I've tried everything I can think of but can't come up with anything. Thanks for your help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tallying
Thanks Fred. But I left out one major detail. The survey is done in excel
but the responses are all handwritten. So what I need to do is find an easy way to tally the results, hopefully by just clicking on a counter button and have it do it for me and then generate a chart. I hope that makes more sense. I looked at the pivot table and I think that will only work if the results were already input into the spreadsheet, correct? My problem is putting the results in. Thanks again, Feenster "Fred Smith" wrote: Yes, it's possible, so you haven't tried everything. Posting a representative sample of your data would help. A lot depends on how it's organized. Also, telling us what you've tried would avoid expending effort that's not worthwhile. In the meantime, you could look at the Sumif/Countif functions and Pivot Tables. I suspect Pivot Tables will do exactly what you want, but they take some effort to learn. -- Regards, Fred "feenster" wrote in message ... Hello. I have created a survey and need to tally the results. It's just a basic survey that has around 50 questions with the selection of O-Outstanding, G-Good, A-Adequate, IN-Improvement Needed and NJ-No Basis for Judgement. I have received over 200 of these surveys and I would like to be able to click on a button and have it tally the results, is this possible in excel? I've tried everything I can think of but can't come up with anything. Thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tallying Lists | Excel Discussion (Misc queries) | |||
tallying a total dependant on contents of another cell | Excel Discussion (Misc queries) | |||
edate and yearfrac functions not tallying | Excel Worksheet Functions | |||
How do you use tallying in excel?? | Charts and Charting in Excel | |||
Tallying columns based on values of 2 different columns | Excel Worksheet Functions |