What is the best way to build thI'is interaction?

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.

Example:

  •  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. 

Example:

  • 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 have a total of four columns.  

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??

1 Reply