What formula do I use to have Excel look at 4 columns (D,E,F,G), the first three (D,E,F) are material size, the fourth (G) is the total of the parts for the material size. I figured it'd be SUMIF, but I can't figure out how to link the first three cells without using TEXTJOIN and creating a list of every possible size. I'd like it to group the results so I'll know what sizes there are and how many sheets are of each size.
Thanks for your help.
<tbody>
</tbody><colgroup><col><col><col><col></colgroup>
Thanks for your help.
SHEET SIZE | # SHEETS | ||
108 | x | 48 | 75 |
102 | x | 48 | 24 |
102 | x | 48 | 67 |
138 | x | 48 | 20 |
102 | x | 48 | 5 |
108 | x | 48 | 5 |
102 | x | 48 | 10 |
108 | x | 48 | 10 |
138 | x | 48 | 10 |
84 | x | 48 | 1 |
84 | x | 48 | 1 |
84 | x | 48 | 1 |
84 | x | 48 | 1 |
90 | x | 48 | 1 |
84 | x | 48 | 1 |
132 | x | 48 | 3 |
108 | x | 48 | 6 |
144 | x | 48 | 2 |
132 | x | 48 | 3 |
144 | x | 48 | 2 |
96 | x | 48 | 6 |
90 | x | 48 | 1 |
66 | x | 48 | 1 |
84 | x | 48 | 1 |
96 | x | 48 | 1 |
96 | x | 48 | 1 |
90 | x | 48 | 1 |
96 | x | 48 | 1 |
96 | x | 48 | 1 |
84 | x | 48 | 2 |
96 | x | 48 | 2 |
72 | x | 48 | 3 |
108 | x | 48 | 75 |
108 | x | 48 | 75 |
84 | x | 48 | 1 |
84 | x | 48 | 1 |
84 | x | 48 | 1 |
84 | x | 48 | 1 |
90 | x | 48 | 1 |
84 | x | 48 | 1 |
<tbody>
</tbody><colgroup><col><col><col><col></colgroup>