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),"") |