Tallying

[feenster]

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.

 

[Fred Smith]

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.

 

[feenster]

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