I have this formula which works at the being of the data, but it seems to get thrown off towards the end of all my data sheets. I thought it was pretty basic, just checking column D and adding the sum of column E for all the lines that have the same value in column D. However, when I get to the value "8000-SPORT GREy-2XL" the output of the formula is "7" when it should be "5" (line 53). Missing something easy?
| SHS-EVENT STORE.xlsx | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | |||
| 1 | |||||||||
| 2 | 8345407 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-2XL | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 3 | 8345936 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-2XL | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | 2 | |||
| 4 | 8345085 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-L | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 5 | 8345320 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-L | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 6 | 8345406 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-L | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 7 | 8345407 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-L | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 8 | 8345421 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-L | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 9 | 8345436 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-L | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 10 | 8345573 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-L | 2 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 11 | 8345836 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-L | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | 9 | |||
| 12 | 8345073 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-M | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 13 | 8345145 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-M | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 14 | 8345146 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-M | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 15 | 8345151 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-M | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 16 | 8345155 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-M | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 17 | 8345227 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-M | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 18 | 8345323 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-M | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 19 | 8345335 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-M | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 20 | 8345433 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-M | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 21 | 8345540 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-M | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 22 | 8345550 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-M | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 23 | 8345628 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-M | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 24 | 8345839 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-M | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 25 | 8346110 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-M | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 26 | 8346372 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-M | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 27 | 8346426 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-M | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | 16 | |||
| 28 | 8345311 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-S | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 29 | 8345426 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-S | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 30 | 8345430 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-S | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 31 | 8345583 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-S | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 32 | 8345879 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-S | 2 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 33 | 8345881 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-S | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 34 | 8345904 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-S | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 35 | 8345938 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-S | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 36 | 8346052 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-S | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 37 | 8346110 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-S | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 38 | 8346339 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-S | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 39 | 8346436 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-S | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | 13 | |||
| 40 | 8345145 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-XL | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 41 | 8345205 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-XL | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 42 | 8345287 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-XL | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 43 | 8345321 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-XL | 2 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 44 | 8345405 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-XL | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 45 | 8345428 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-XL | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 46 | 8345436 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-XL | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 47 | 8346110 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-XL | 3 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 48 | 8346367 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-XL | 1 | CENTER FRONT AND FULL BACK SP: 3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | 12 | |||
| 49 | 8347149 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-2XL | 1 | CENTER FRONT AND FULL BACK SP:3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 50 | 8348603 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-2XL | 1 | CENTER FRONT AND FULL BACK SP:3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 51 | 8348765 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-2XL | 1 | CENTER FRONT AND FULL BACK SP:3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 52 | 8349343 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-2XL | 1 | CENTER FRONT AND FULL BACK SP:3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | ||||
| 53 | 8349597 | SOUTHSIDE-FEAR THE FIN FOOTBAL | 8000-SPORT GREY-2XL | 1 | CENTER FRONT AND FULL BACK SP:3 COLOR FRONT & 2 COLOR BACK DESIGN (00120SP) | 7 | |||
Sheet1 | |||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| G2:G53 | G2 | =IF(D2<>D3,SUMIF(D$2:D2,D2,E$2:E2),"") |
