survey

[Pammy]

If I set up a form survey, and users fill them out on-line, is there a way I
could set up a spreadsheet that would count all the passed for each question
and all the failed without having to count them manual?

Thanks,

 

[Bernie Deitrick]

Pammy,

If your users' answers are saved in a database file, you could open the database in Excel and then
use COUNTIF functions for each of the answers to find out how many are correct...

For example, if the column A entries should be Yes, then

=COUNTIF(A:A,"Yes")

will count the number of correct values.

Or enter the formula like

=COUNTIF(A3:A25000, A1)

and enter Yes in cell A1 - makes it easier to copy the formula to all columns - just update the
value in the first row of each column to the 'correct' response.

HTH,
Bernie
MS Excel MVP