Duncan,

I do agree that using your array idea will work, but as you say the
simplest solution is the extra column, or just to use the totals from
each column already there.

However, there is no need to divide by 10 for the right answer, I am
unsure as to why you need to do this.

Steve