Spreadsheet: 149943d1334213705-excel-2007-sum-values-for-multiple-answers-example
Sheet: Ark1

 |  |  | Areas with pain |  | Areas with pain
 |  |  | 14 |  | 1,7,8
 |  |  | 14 |  | 11
 |  |  | 14 |  | 8,10,13
 |  |  | 1,2,3,13 |  | 2,8,9,11,12
 |  |  | 1,4,5,6 |  | 8.11
 |  |  | 1,2,4,8,13 |  | 14
 |  |  | 14 |  | 7,8,11
 |  |  | 1.2 |  | 10
 |  |  | 11 |  | 11.14
 |  |  | 2.7 |  | 1,7,11
 |  |  | 14 |  | 14
 |  |  | 14 |  | 11
 |  |  | 2 |  | 2,6,12
 |  |  | 1,2,7,11 |  | 1
 |  |  | 1.2 |  | 11
 |  |  | 11 |  | 2
 |  |  | 14 |  | 11
 |  |  | 14 |  | 1,8,11
 |  |  | 1,2,8 |  | 1,7,8
 |  |  | 13 |  | 11
 |  |  | 2 |  | 8,10,13
 |  |  | 2 |  | 2,8,9,11,12
 |  |  | 13 |  | 8.11
 |  |  | 1,2,3 |  | 14
 |  |  | 14 |  | 7,8,11
 |  |  | 11 |  | 10
 |  |  | 1 |  | 11.14
 |  |  | 14 |  | 1,7,11
 |  |  | 1 |  | 14
 |  |  |  |  | 11
 |  |  | 1,2,11 |  | 2,6,12
 |  |  | 12 |  | 1
 |  |  | 1,7,8,11 |  | 11
 |  |  | 1.2 |  | 2
 |  |  | 2 |  | 11
 |  |  | 1,2,8 |  | 1,8,11
 |  |  | 6,10,11 |  | 1,7,8
 |  |  | 8 |  | 11
 |  |  | 13 |  | 8,10,13
 |  |  | 1,2,7,8 |  | 2,8,9,11,12
 |  |  | 2,3,4,8,10,11 |  | 8.11
 |  |  | 14 |  | 14
 |  |  | 5.7 |  | 7,8,11
 |  |  | 14 |  | 10
 |  |  | 14 |  | 11.14
 |  |  | 1,2,6 |  | 1,7,11
 |  |  | 14 |  | 14
 |  |  | 7 |  | 11
 |  |  | 1,2,7,8 |  | 2,6,12
 |  |  | 1,2,4 |  | 1
 |  |  | 1 |  | 11
 |  |  | 6 |  | 2
 |  |  | 1 |  | 11
 |  |  |  |  | 1,8,11
 |  |  | 1.4 |  | 1,7,8
 |  |  | 1,2,8 |  | 11
 |  |  | 4.11 |  | 8,10,13
 |  |  | 14 |  | 2,8,9,11,12
 |  |  | 2,3,7,9,11 |  | 8.11
 |  |  | 2 |  | 14
 |  |  | 12 |  | 7,8,11
 |  |  |  |  | 10
 |  |  | 2,4,11 |  | 11.14
 |  |  | 14 |  | 1,7,11
 |  |  | 1,2,11 |  | 14
 |  |  | 8.14 |  | 11
 |  |  | 1.2 |  | 2,6,12
 |  |  | 5 |  | 1
 |  |  | 10 |  | 11
 |  |  | 1.8 |  | 2
 |  |  | 2 |  | 11
 |  |  | 11 |  | 1,8,11
 |  |  | 14 |  | 1,7,8
 |  |  | 1.2 |  | 11
 |  |  | 4,5,11 |  | 8,10,13
 |  |  | 14 |  | 2,8,9,11,12
 |  |  | 6,11,13 |  | 8.11
 |  |  | 3 |  | 14
 |  |  | 14 |  | 7,8,11
 |  |  | 12 |  | 10
 |  |  | 14 |  | 11.14
 |  |  | 14 |  | 1,7,11
 |  |  | 14 |  | 14
 |  |  |  |  | 11
 |  |  | 14 |  | 2,6,12
 |  |  |  |  | 1
 |  |  | 1 |  | 11
 |  |  | 8 |  | 2
 |  |  | 1,2,3,7,10,11 |  | 11
 |  |  | 7.8 |  | 1,7,8
 |  |  | 1,2,3,8,11 |  | 11
 |  |  | 1 |  | 8,10,13
 |  |  | 14 |  | 2,8,9,11,12
 |  |  | 1 |  | 8.11
 |  |  | 14 |  | 14
 |  |  | 8 |  | 7,8,11
 |  |  | 1.2 |  | 10
 |  |  | 14 |  | 11.14
 |  |  | 12.13 |  | 1,7,11
 |  |  | 1,2,3,4,8 |  | 14
 |  |  | 14 |  | 11
 |  |  | 8 |  | 2,6,12
 |  |  | 1,2,3 |  | 1
 |  |  | 11 |  | 11
 |  |  | 2.7 |  | 2
 |  |  | 14 |  | 11
 |  |  |  |  | 1,8,11
 |  |  |  |  | 1,7,8
 |  |  |  |  | 11
 |  |  |  |  | 8,10,13
 |  |  |  |  | 2,8,9,11,12
 |  |  |  |  | 8.11
 |  |  |  |  | 14
 |  |  |  |  | 7,8,11
 |  |  |  |  | 10
 |  |  |  |  | 11.14
 |  |  |  |  | 1,7,11
 |  |  |  |  | 14
 |  |  |  |  | 11
 |  |  |  |  | 2,6,12
 |  |  |  |  | 1
 |  |  |  |  | 11
 |  |  |  |  | 2
 |  |  |  |  | 11
 |  |  |  |  | 1,8,11
 |  |  |  |  | 1,7,8
 |  |  |  |  | 11
 |  |  |  |  | 8,10,13
 |  |  |  |  | 2,8,9,11,12
 |  |  |  |  | 8.11
 |  |  |  |  | 14
 |  |  |  |  | 7,8,11
 |  |  |  |  | 10
 |  |  |  |  | 11.14
 |  |  |  |  | 1,7,11
 |  |  |  |  | 14
 |  |  |  |  | 11
 |  |  |  |  | 2,6,12
 |  |  |  |  | 1
 |  |  |  |  | 11
 |  |  |  |  | 2
 |  |  |  |  | 11
 |  |  |  |  | 1,8,11
 |  |  |  |  | 2
 |  |  |  |  | 11
 |  |  |  |  | 1,8,11