Sure, ok. I have a survey by participant (100 participants) which are my observation data (rows). Each survey has 20 questions. I have some participant background info and 20 survey questions q1-q20. I need to add all the numbers that each participant gave for each question to create a score. If I were using excel, it would be SUM(B2:U2), with the next column storing the resulting total. Does this help? The format is basically: ParticipantID Q1 Q2 Q3 Q4 1 2 3 4 2 2 1 1 2 1 The totals I need are by adding all question data per participant, or by row. Hence, participant 1 total would = 11 and participant 2 would = 5 .
... View more