Summarise a Questionnaire (2000)

I have a list of clients in column A and questions running across from B1. The responses of the clients are yes, no, n/a, and sometimes >10, >20, etc. I want to create totals for all the answers. Is it possible to do this using a Pivot Table? How else would you tackle it? Andy.