Spreadsheet: 159902d1338897973-need-easier-way-to-fill-in-blank-cells-to-sum-a-column-of-exported-data-example-of-finding-sum-of-above
Sheet: 2011 Detail

 | The green highlighted cell is the Grouping number that is exported.
 | The yellow highlighted cells are the totals that are exported.
 | The blue is my formula that I have to put in to be able to see the total of that grouping number.
 | I have to drag the grouping number into the blank spaces to the Total.
 |  |  |  |  |  |  |  |  | BASE MATERIAL |  |  | BASE | COMPONENT |  | SECT
 | BASE CODE | GROUPING-NUM | Generic NAME | F | P | R | A | C | CONSUMPTION | PCT | CONSUMED | DAILY AVG | MAX MONTH | AVG | MAX | EHS | SOLID
1 | B16 | 123-456 | Cotton
2 | [NAME] |  |  | Y |  |  | Y |  | 84579 | 14.7 | 12450 | 927 | 1922
3 | G2 |  |  | Y |  |  | Y |  | 28356 | 7.6 | 2155 | 195 | 545
4 | G3 |  |  | Y |  |  | Y |  | 441 |  | 0 | 0 | 0
5 | G4 |  |  | Y |  |  | Y |  | 196523 | 0.3 | 589 | 67 | 140
6 | G5 |  |  | Y |  | Y | Y |  | 41 | 16.2 | 6 | 2 | 4
7 | G6 |  |  | Y |  |  | Y |  | 86816 | 7.8 | 6771 | 535 | 1081
8 | G7 |  |  | Y |  |  | Y |  | 10747 | 16 | 1719 | 164 | 392
9 | G8 |  |  | Y |  |  | Y |  | 4175 | 9 | 375 | 66 | 119
10 | G9 |  |  | Y |  |  | Y |  | 4595 | 4.8 | 220 | 33 | 65
11 | G10 |  |  | Y |  | Y | Y |  | 22710 | 0.2 | 63 | 2 | 8
12 | G11 |  |  | Y |  |  | Y |  | 1281 | 15 | 192 | 26 | 51
13 | G12 |  |  | Y |  |  | Y |  | 21542 | 14 | 3016 | 225 | 524
14 | G13 |  |  | Y |  |  | Y |  | 1079 | 0.1 | 1 | 0 | 0
15 | G14 |  |  | Y |  |  | Y |  | 8333 | 14.3 | 1191 | 269 | 463
16 | [NAME] |  |  |  |  |  |  |  | 46004 |  | 1 | 0 | 0
17 | [NAME] |  |  | Y |  |  | Y |  | 37 | 10.4 | 3 | 0 | 1
18 | G17 |  |  | Y |  |  | Y |  | 535 | 12.6 | 67 | 8 | 19
19 | G18 |  |  | Y |  |  | Y |  | 5198 | 2.2 | 116 | 17 | 35
20 | B12 |  |  | Y |  |  |  |  | 1785830 |  | 285 | 21 | 46
21 | B13 |  |  | Y |  |  | Y |  | 2259954 |  | 2237 | 194 | 322
22 | B14 |  |  | Y |  |  | Y |  | 483890 | 0.2 | 1393 | 137 | 301
23 | B15 |  |  | Y |  |  | Y |  | 8247264 | 20 | 1649452 | 114116 | 212033
24 | C2 |  |  | Y |  | Y | Y |  | 8071 | 0.1 | 8 | 1 | 2
25 | [NAME] |  |  | Y |  | Y | Y |  | 195 |  | 0 | 0 | 0
26 | C4 |  |  | Y |  | Y | Y |  | 94 |  | 0 | 0 | 0
27 | C5 |  |  | Y |  | Y | Y |  | 315 |  | 0 | 0 | 0
28 | C6 |  |  | Y |  | Y | Y |  | 3345 |  | 2 | 0 | 0
29 | C7 |  |  | Y |  | Y | Y |  | 51 |  | 0 | 0 | 0
30 | C8 |  |  | Y |  | Y | Y |  | 4524 |  | 2 | 0 | 0
31 | C9 |  |  | Y |  | Y | Y |  | 24 |  | 0 | 0 | 0
32 | C10 |  |  | Y |  |  |  |  | 1710 | 0.8 | 13 | 1 | 3
33 | C11 |  |  | Y |  |  |  |  | 31 | 0.1 | 0 | 0 | 0
34 | C12 |  |  | Y |  |  | Y |  | 48 | 0.1 | 0 | 0 | 0
35 | C13 |  |  | Y |  |  |  |  | 161 | 0.1 | 0 | 0 | 0
36 | C14 |  |  | Y |  |  |  |  | 9 | 0.1 | 0 | 0 | 0
37 | C15 |  |  | Y |  |  |  |  | 1731 | 0.1 | 1 | 0 | 0
38 | C16 |  |  | Y |  | Y | Y |  | 24495 |  | 6 | 0 | 0
39 | C17 |  |  | Y |  | Y | Y |  | 9980 |  | 3 | 0 | 0
40 | C18 |  |  | Y |  | Y | Y |  | 2616 |  | 0 | 0 | 0
41 | C19 |  |  | Y |  | Y | Y |  | 40523 |  | 11 | 0 | 0
42 | C20 |  |  | Y |  | Y | Y |  | 14897 |  | 5 | 0 | 0
43 | C21 |  |  | Y |  | Y | Y |  | 4289 |  | 1 | 0 | 0
44 | C22 |  |  | Y |  |  |  |  | 30907 |  | 13 | 1 | 3
45 | D6 |  |  |  |  |  |  |  | 17228 |  | 10 | 1 | 1
46 | D7 |  |  | Y |  | Y | Y |  | 2086 |  | 1 | 0 | 0
47 | D8 |  |  | Y |  |  | Y |  | 8442 | 3 | 258 | 49 | 89
48 | D9 |  |  | Y |  |  | Y |  | 80845 | 3 | 2473 | 460 | 914
49 |  | TOTAL |  |  |  |  |  |  | ------------ |  | ----------- | ------------ | ------------
50 |  | TOTAL |  |  |  |  |  | Y | 13556569 |  | 1685128 | 117532 | 219100
51
52 |  | 467-342 | [NAME]
53 | A1 | 467-342 |  | Y |  | Y | Y |  | 1826515 | 99.9 | 1826332 | 104302 | 210380
54 |  | TOTAL |  |  |  |  |  |  | ------------ |  | ----------- | ------------ | ------------
55 |  | 467-342 TOTAL |  |  |  |  |  |  | 1826515 |  | 1826332 | 104302 | 210380
56
57 | z1 | 241-968 | Wool
58 | z2 |  |  | Y |  |  | Y |  | 12027 | 100 | 12027 | 366 | 850
59 |  | TOTAL |  |  |  |  |  |  | ------------ |  | ----------- | ------------ | ------------
60 |  | TOTAL |  |  |  |  |  | Y | 12027 |  | 12027 | 366 | 850
61
62 | B16 | 975-842 | Blend
63 | C23 |  |  | Y |  |  | Y |  | 51846 | 2 | 1036 | 69 | 132
64 | C24 |  |  | Y |  | Y | Y |  | 3179 | 0.9 | 30 | 3 | 7
65 | C25 |  |  | Y |  |  | Y |  | 4595 | 0.8 | 36 | 5 | 10
66 | C26 |  |  | Y |  |  | Y |  | 1079 | 0.2 | 2 | 0 | 0
67 | C27 |  |  | Y |  |  |  |  | 52 | 1.9 | 1 | 0 | 0
68 | C28 |  |  | Y |  | Y | Y |  | 4931 | 0.9 | 44 | 7 | 11
69 | C29 |  |  | Y |  |  | Y |  | 96005 | 1 | 986 | 71 | 153
70 | B17 |  |  | Y |  |  | Y |  | 483890 | 0.6 | 2903 | 286 | 627
71 | B18 |  |  | Y |  |  | Y |  | 2092401 | 4 | 83696 | 6587 | 14140
72 | B19 |  |  | Y |  |  | Y |  | 4722 | 1.9 | 92 | 4 | 4
73 | G19 |  |  | Y |  | Y | Y |  | 8071 | 0.2 | 16 | 3 | 5
74 | G20 |  |  | Y |  | Y | Y |  | 195 | 0.7 | 1 | 0 | 0
75 | G21 |  |  | Y |  | Y | Y |  | 94 | 0.7 | 0 | 0 | 0
76 | G22 |  |  | Y |  | Y | Y |  | 315 | 0.7 | 2 | 0 | 0
77 | G23 |  |  | Y |  | Y | Y |  | 10429 | 0.3 | 36 | 5 | 11
78 | [NAME] |  |  | Y |  | Y | Y |  | 3345 | 0.7 | 25 | 3 | 6
79 | G25 |  |  | Y |  | Y | Y |  | 6902 | 0.3 | 26 | 6 | 10
80 | G26 |  |  | Y |  | Y | Y |  | 51 | 0.2 | 0 | 0 | 0
81 | G27 |  |  | Y |  | Y | Y |  | 84084 | 0.6 | 504 | 83 | 167
82 | G28 |  |  | Y |  | Y | Y |  | 4524 | 0.7 | 33 | 3 | 6
83 | G29 |  |  | Y |  |  | Y |  | 119 | 0.7 | 0 | 0 | 0
84 | G30 |  |  | Y |  | Y | Y |  | 24 | 0.9 | 0 | 0 | 0
85 | G31 |  |  | Y |  | Y | Y |  | 3872 | 0.7 | 29 | 3 | 7
86 | G32 |  |  | Y |  | Y | Y |  | 4849 | 0.8 | 38 | 3 | 8
87 | G33 |  |  | Y |  | Y | Y |  | 24532 | 0.5 | 127 | 19 | 33
88 | G34 |  |  | Y |  | Y | Y |  | 13255 | 0.2 | 26 | 4 | 7
89 | G35 |  |  | Y |  | Y | Y |  | 4643 | 0.2 | 12 | 1 | 2
90 | G36 |  |  | Y |  | Y | Y |  | 36127 | 0.6 | 225 | 31 | 64
91 | G37 |  |  | Y |  | Y | Y |  | 24495 | 0.6 | 152 | 4 | 10
92 | G38 |  |  | Y |  | Y | Y |  | 9980 | 0.7 | 75 | 3 | 3
93 | G39 |  |  | Y |  | Y | Y |  | 2616 | 0.6 | 16 | 0 | 2
94 | G40 |  |  | Y |  | Y | Y |  | 40523 | 0.6 | 254 | 2 | 4
95 | G41 |  |  | Y |  | Y | Y |  | 14897 | 0.7 | 107 | 3 | 6
96 | G42 |  |  | Y |  | Y | Y |  | 4289 | 0.5 | 25 | 0 | 0
97 | [NAME] |  |  | Y |  |  |  |  | 30907 | 0.6 | 213 | 23 | 55
98 | F25 |  |  | Y |  |  | Y |  | 598 | 1 | 5 | 1 | 2
99 | F26 |  |  | Y |  | Y | Y |  | 2086 | 0.7 | 15 | 2 | 4
100 | F27 |  |  | Y |  |  | Y |  | 8442 | 0.4 | 40 | 7 | 13
101 | [NAME] |  |  | Y |  |  | Y |  | 80845 | 0.4 | 384 | 71 | 142
102 | F29 |  |  | Y |  | Y | Y |  | 7579 | 0.7 | 57 | 12 | 27
103 |  | TOTAL |  |  |  |  |  |  | ------------ |  | ----------- | ------------ | ------------
 |  | TOTAL |  |  |  |  |  |  | 3175388 | 31.4 | 91269 | 7324 | 15678