Help Please - I need assistance with an interaction I'd like to build
I'm attempting to build in interaction and I'm not sure of the best approach.
The user has 18 sets of questions. On each set (A or B) the use enters a number from 1 to 3 between the two questions.
set #1 A=2, B=1
set #2 A=0, B=3
set #3 A=1, B=2
I need the numbers to distribute across four columns, then total each column.
Column O accumulates the numeric entries from 1A, 3B, 5A, 7B and so on
Column C holds the numeric entries of 1B, 3A, 5B and so on
Column D accumulates the numeric entries from 2B, 4A, 6B etc.
Column I accumulates the numeric entries of 2A, 4B, 6,B etc.
I thought I should have a text entry next to each questions, but I'm not sure how to get the numeric entry to each question to accumulate into a specified column. Any ideas or suggestions on a different approach?