Excel

Hi Paul,

Thank you for your question.

I assume you would want each question and the count of yes's, no's and maybe's for each question?

You could use a CountIf function:

=countif(Range of cells with the numbers in,criteria such as 1)

e.g. =countif(a6:f16,1)

This will count how many times 1 was entered into that cell range.

Is your data arranged in columns with column headings? If so you could create a Pivot Table.

Please find a link below on how to create a Pivot Table.

http://www.howtogeek.com/howto/6416/how-to-create-a-pivot-table-in-excel-2007/

I hope this helps.

Regards

Simon