Total "Yes" in survey form

[trevors]

Hi .......

I have a survey form with about 30 questions (Yes/No). I need to count the total of "Yes" on all the serveys. Simple .................... for some ;-)

Trevor

[danjacoby]

Do you need a total of "Yes" answers to each question, or just the total of "Yes" answers?

If the latter, create a calc field that checks each answer and adds 1 for each "Yes". [if(AnswerOne = "Yes", 1, 0) + If(AnswerTwo = "Yes", 1, 0) + If(Answerthree = "Yes", 1, 0)...]

If the former, you'll need a separate calc field that returns a 1 for "Yes" and a 0 for "No".

You can then create a summary field that totals the calc field(s).