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.