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 |
