Spreadsheet: 81995d1282073316-filter-and-sum-like-part-numbers-demo-sheet
Sheet: Bill of Materials

Part Number | Description | Quantity
 |  | Per Sub Assembly | Per Assembly
10001 | Assembly 1 | 1 | 1
10002 | Sub Assembly 1 | 1 | 1
10003 | Part 1 | 1 | 1
10004 | Part 2 | 1 | 1
10005 | Part 3 | 2 | 2
10006 | Part 4 | 2 | 2
10007 | Part 5 | 2 | 2
10008 | Part 6 | 6 | 6
10009 | Part 7 | 3 | 3
10010 | Sub Assembly 2 | 1 | 1
10011 | Part 8 | 2 | 2
10012 | Part 9 | 2 | 2
10013 | Part 10 | 2 | 2
10014 | Part 11 | 4 | 4
10015 | Part 12 | 2 | 2
10016 | Part 13 | 4 | 4
10017 | Part 14 | 4 | 4
10018 | Part 15 | 4 | 4
10019 | Part 16 | 2 | 2
10020 | Part 17 | 6 | 6
10021 | Part 18 | 10 | 10
10022 | Part 19 | 2 | 2
10023 | Part 20 | 20 | 20
10024 | Part 21 | 20 | 20
10025 | Part 22 | 4 | 4
10026 | Sub Assembly 3 | 1 | 55
10027 | Part 23 | 1 | 55
10028 | Part 24 | 2 | 110
10029 | Part 25 | 2 | 110
10030 | Part 26 | 2 | 110
10031 | Part 27 | 1 | 110
10032 | Part 28 | 1 | 110
10033 | Sub Assembly 4 | 1 | 1
10034 | Part 29 | 1 | 1
10035 | Part 30 | 1 | 1
10036 | Part 31 | 12 | 12
10037 | Part 32 | 12 | 12
10038 | Part 33 | 12 | 12
10039 | Part 34 | 12 | 12
10040 | Part 35 | 110 | 110
10041 | Sub Assembly 5 | 1 | 4
10042 | Part 36 | 1 | 4
10043 | Part 37 | 1 | 4
10044 | Part 38 | 1 | 4
10045 | Sub Assembly 6 | 1 | 12
10046 | Part 39 | 1 | 12
10047 | Part 40 | 2 | 24
10048 | Part 41 | 1 | 55
10049 | Part 42 | 1 | 55
10050 | Part 43 | 1 | 55
10051 | Part 44 | 1 | 55
10052 | Part 45 | 1 | 55
10053 | Part 46 | 1 | 12
10054 | Part 47 | 1 | 12
10055 | Sub Assembly 7 | 1 | 2
10056 | Part 48 | 1 | 2
10057 | Part 49 | 1 | 2
10058 | Part 50 | 1 | 2
10059 | Part 51 | 1 | 2
10060 | Part 52 | 4 | 8
10061 | Sub Assembly 8 | 1 | 2
10062 | Part 53 | 1 | 2
10063 | Part 54 | 1 | 2
10064 | Part 55 | 1 | 2
10065 | Part 56 | 1 | 2
10066 | Part 57 | 4 | 8
10001 | Assembly 2 | 1 | 1
10002 | Sub Assembly 9 | 1 | 1
10003 | Part 1 | 1 | 1
10004 | Part 2 | 1 | 1
10005 | Part 3 | 2 | 2
10006 | Part 4 | 2 | 2
10067 | Part 58 | 2 | 2
10068 | Part 59 | 6 | 6
10069 | Part 60 | 3 | 3
10010 | Sub Assembly 10 | 1 | 1
10070 | Part 61 | 2 | 2
10071 | Part 62 | 2 | 2
10072 | Part 63 | 2 | 2
10073 | Part 64 | 4 | 4
10074 | Part 65 | 2 | 2
10016 | Part 13 | 4 | 4
10017 | Part 14 | 4 | 4
10018 | Part 15 | 4 | 4
10019 | Part 16 | 2 | 2
10020 | Part 17 | 6 | 6
10021 | Part 18 | 10 | 10
10022 | Part 19 | 2 | 2
10023 | Part 20 | 20 | 20
10024 | Part 21 | 20 | 20
10025 | Part 22 | 4 | 4
10026 | Sub Assembly 11 | 1 | 88
10075 | Part 66 | 1 | 55
10076 | Part 67 | 2 | 110
10029 | Part 25 | 2 | 110
10030 | Part 26 | 2 | 110
10031 | Part 27 | 1 | 110
10032 | Part 28 | 1 | 110
10033 | Sub Assembly 4 | 1 | 1
10034 | Part 29 | 1 | 1
10035 | Part 30 | 1 | 1
10036 | Part 31 | 12 | 12
10037 | Part 32 | 12 | 12
10038 | Part 33 | 12 | 12
10039 | Part 34 | 12 | 12
10040 | Part 35 | 110 | 110
10041 | Sub Assembly 5 | 1 | 4
10042 | Part 36 | 1 | 4
10043 | Part 37 | 1 | 4
10044 | Part 38 | 1 | 4
10045 | Sub Assembly 6 | 1 | 12
10046 | Part 39 | 1 | 12
10047 | Part 40 | 2 | 24
10048 | Part 41 | 1 | 55
10049 | Part 42 | 1 | 55
10050 | Part 43 | 1 | 55
10051 | Part 44 | 1 | 55
10052 | Part 45 | 1 | 55
10053 | Part 46 | 1 | 12
10054 | Part 47 | 1 | 12
10055 | Sub Assembly 7 | 1 | 2
10056 | Part 48 | 1 | 2
10057 | Part 49 | 1 | 2
10058 | Part 50 | 1 | 2
10059 | Part 51 | 1 | 2
10060 | Part 52 | 4 | 8
10061 | Sub Assembly 8 | 1 | 2
10062 | Part 53 | 1 | 2
10063 | Part 54 | 1 | 2
10064 | Part 55 | 1 | 2
10065 | Part 56 | 1 | 2
10066 | Part 57 | 4 | 8
10133 | Assembly 3 | 1 | 1
10134 | Part 68 | 4
10135 | Part 69 | 32
10136 | Part 70 | 32
10137 | Part 71 | 32
10138 | Part 72 | 32
10139 | Part 73 | 3
10140 | Part 74 | 1
10141 | Part 75 | 1
10142 | Part 76 | 1
10143 | Part 77 | 11
10144 | Part 78 | 1
10145 | Part 79 | 1
10146 | Part 80 | 1
10147 | Part 81 | 1
10148 | Part 82 | 1
10149 | Part 83 | 1
10150 | Assembly 4 | 1 | 1
10134 | Part 68 | 2
10135 | Part 69 | 16
10136 | Part 70 | 16
10137 | Part 71 | 16
10138 | Part 72 | 16
10139 | Part 73 | 2
10140 | Part 74 | 1
10141 | Part 75 | 1
10142 | Part 76 | 8
10143 | Part 77 | 1
10144 | Part 78 | 1
10145 | Part 79 | 1
10146 | Part 80 | 1
10164 | Assembly 5 | 1 | 1
10141 | Part 75 | 1 | 1
10142 | Part 76 | 4 | 4
10143 | Part 77 | 1 | 1
10144 | Part 78 | 1 | 1
10145 | Part 79 | 2
10146 | Part 80
10147 | Part 81 | 4
10148 | Part 82 | 4
10149 | Part 83 | 3
10151 | Part 85 | 2
10152 | Part 86 | 3
10153 | Part 87 | 4
10154 | Part 88 | 2
10155 | Part 89 | 1