Spreadsheet: 188122d1350682030-sumproduct-help-with-horizontal-arrangement-book2
Sheet: Example

Name: | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | Michelle |  | [NAME]
 | East | East | East | East | West | West | East | East | West | West | West | West | East | East | West | West
District: | East |  | East |  | West |  | East |  | West |  | West |  | East |  | West |  |  |  |  | East |  |  | West
 | Sales $ | Hours | Sales $ | Hours | Sales $ | Hours | Sales $ | Hours | Sales $ | Hours | Sales $ | Hours | Sales $ | Hours | Sales $ | Hours |  |  |  | Sales $ | Hours | Sumprod | Sales $ | Hours | Sumprod
Week 1 | 84 | 12 | 317 | 11.5 | 149 | 16 | 1212 | 40 | 836 | 40 | 828 | 40 | 1200 | 40 | 1513 | 40 |  |  |  | 2813 | 103.5 |  | 3326 | 136
Week 2 | 84 | 15 | 435 | 7.5 | 84 | 8 | 1366 | 40 | 1015 | 40 | 1164 | 40 | 1470 | 40 | 1753 | 40 |  |  |  | 3355 | 102.5 |  | 4016 | 128
Week 3 | 366 | 15 | 0 | 0 | 168 | 8 | 1892 | 40 | 917 | 40 | 660 | 40 | 1182 | 40 | 816 | 40 |  |  |  | 3440 | 95 |  | 2561 | 128
Week 4 | 233 | 11.5 | 687 | 8 | 0 | 8 | 1119 | 24 | 816 | 40 | 888 | 40 | 1307 | 40 | 1144 | 40 |  |  |  | 3346 | 83.5 |  | 2848 | 128
Week 5 | 252 | 11.5 | 317 | 4 | 0 | 0 | 2494 | 40 | 956 | 40 | 540 | 40 | 941 | 40 | 1451 | 40 |  |  |  | 4004 | 95.5 |  | 2947 | 120
Week 6 | 946 | 19.5 | 0 | 0 | 0 | 0 | 2327 | 40 | 685 | 40 | 828 | 40 | 527 | 16 | 1347 | 40 |  |  |  | 3800 | 75.5 |  | 2860 | 120
Week 7 | 699 | 12 | 599 | 7.5 | 0 | 0 | 2722 | 40 | 0 | 0 | 858 | 40 | 0 | 0 | 1699 | 40 |  |  |  | 4020 | 59.5 |  | 2557 | 80
Week 8 | 84 | 15 | 783 | 15 | 0 | 0 | 2009 | 40 | 0 | 0 | 1131 | 40 | 0 | 0 | 1903 | 40 |  |  |  | 2876 | 70 |  | 3034 | 80
Week 9 | 401 | 15 | 0 | 0 | 233 | 4 | 1394 | 40 | 0 | 0 | 600 | 40 | 0 | 0 | 1209 | 40 |  |  |  | 1795 | 55 |  | 2042 | 84
Week 10 | 0 | 14 | 550 | 8 | 0 | 0 | 1705 | 40 | 0 | 0 | 402 | 40 | 1566 | 40 | 1754 | 40 |  |  |  | 3821 | 102 |  | 2156 | 80
Week 11 | 737 | 15 | 816 | 12 | 0 | 0 | 1160 | 40 | 0 | 0 | 0 | 0 | 1114 | 40 | 1202 | 40 |  |  |  | 3827 | 107 |  | 1202 | 40
Week 12 | 504 | 15 | 672 | 11.5 | 233 | 4 | 968 | 40 | 0 | 0 | 0 | 0 | 2158 | 40 | 731 | 32.32 |  |  |  | 4302 | 106.5 |  | 964 | 36.32
Week 13 | 984 | 23.5 | 0 | 0 | 401 | 16 | 1625 | 40 | 0 | 0 | 0 | 0 | 1399 | 40 | 0 | 0 |  |  |  | 4008 | 103.5 |  | 401 | 16
Week 14 | 382 | 15.5 | 336 | 8 | 168 | 16 | 1508 | 40 | 382 | 15.5 | 336 | 8 | 168 | 16 | 0 | 0 |  |  |  | 2394 | 79.5 |  | 886 | 39.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | East |  |  | West
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sales $ | Hours | Sumprod | Sales $ | Hours | Sumprod
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2813 | 103.5 | 101133.5 | 3326 | 136 | 129464
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3355 | 102.5 | 117962.5 | 4016 | 128 | 157952
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3440 | 95 | 128450 | 2561 | 128 | 97064
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3346 | 83.5 | 87311.5 | 2848 | 128 | 113920
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4004 | 95.5 | 141566 | 2947 | 120 | 117880
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3800 | 75.5 | 119959 | 2860 | 120 | 114400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4020 | 59.5 | 121760.5 | 2557 | 80 | 102280
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2876 | 70 | 93365 | 3034 | 80 | 121360
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1795 | 55 | 61775 | 2042 | 84 | 73292
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3821 | 102 | 135240 | 2156 | 80 | 86240
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3827 | 107 | 111807 | 1202 | 40 | 48080
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4302 | 106.5 | 140328 | 964 | 36.32 | 24557.92
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4008 | 103.5 | 144084 | 401 | 16 | 6416
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2394 | 79.5 | 71617 | 886 | 39.5 | 11297