I am using Office 365 and I am needing a formula to do the following. I need to total the number of parts parts needed for each zone when a certain number is in the column above the part name. Example: I need to know the sum of the parts for zone 205 that has the number 36 above it. Which would be 8. I can't seem to crack the code on this one and any help is appreciated
A | B | C | D | E | F | G | H | I | J | K | L | M | N | 0 |
36 | 36 | 38 | 40 | 36 | 36 | 36 | 38 | 40 | 44 | 46 | 36 | 36 | ||
Zone# | Total Parts | Bolts | Washers | Nuts | Sprocket | Table | Leg | Back | Foot | Middle | Spacer | Wing | Left End | Right End |
205 | 8 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||
206 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||||
207 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||||||
208 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ||||||
209 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||
210 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | |||
211 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 2 | 1 | 2 | 2 |