Spreadsheet: 674138d1587673321-sumif-multiple-criteria-2020-04-23-oeldere-pt-674133d1587672350-sumif-multiple-criteria-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | 214
Kolom1 | Kolom2 | Kolom3 | Kolom4 | Kolom5 | Kolom6 | Kolom7 | Kolom8 | Kolom9 | Kolom10 | Kolom11 | Kolom12 | Kolom13 | criteria
11-00004 | 213400 | Superintendent             PBG | 213400-Superintendent | 114813 | 49747 | 4068 | 164560 | 1503 | 62916.9 | 252 | 11347.38 | PBG
11-00004 | 214000 | Material Handling          PBG | 214000-Material Handling | 30 | 0 | 1 | 30 | 1289.5 | 32966.99 | 189 | 4237.88 | PBG
11-00004 | 214001 | Ship & Receive             PBG | 214001-Ship & Receive | 30 | 0 | 1 | 30 | 611.5 | 16612.5 | 54.5 | 1481.25 | PBG
11-00004 | 214500 | Pipe Fabrication           PBG | 214500-Pipe Fabrication | 75000 | 8960 | 3320 | 83960 | 1217.5 | 28452.01 | 129 | 3838.25 | PBG
11-00004 | 221316 | UG W&V                     PBG | 221316-UG W&V | 290700 | 31263 | 10715 | 321963 | 6608.5 | 145730.95 | 0 | 0 | PBG
11-00004 | 221317 | AG W&V | 221317-AG W&V | 1 | 0 | 1 | 1 | 877.5 | 18588.45 | 97.5 | 1402.88 | PBG
11-00004 | 224000 | Plumb Fixt | 224000-Plumb Fixt | 0 | 0 | 0 | 0 | 58 | 1401.25 | 58 | 1401.25 | PBG
11-00004 | 231123 | Nat Gas | 231123-Nat Gas | 0 | 16104 | 528 | 16104 | 1305.5 | 40599.2 | 281 | 7901 | PBG
11-00004 | 232213 | Stm & Cond | 232213-Stm & Cond | 1 | 0 | 1 | 1 | 2173.5 | 60159.36 | 60 | 1025.9 | PBG
11-00004 | 235204 | Interstitial Loop | 235204-Interstitial Loop | 1 | 0 | 1 | 1 | 4148.5 | 123679.85 | 10 | 237.5 | PBG
11-00004 | 235205 | Interstitial Branches | 235205-Interstitial Branches | 1 | 49472 | 1623 | 49473 | 3418.5 | 101236.56 | 1590.5 | 43539.08 | PBG
11-00004 | 235206 | Boiler Room | 235206-Boiler Room | 1 | 2806 | 93 | 2807 | 5095.5 | 136904.2 | 92 | 2679.63 | PBG
11-00004 | 235207 | Plant Drops | 235207-Plant Drops | 1 | 35700 | 1171 | 35701 | 1160.25 | 31195.81 | 879.5 | 21625.93 | PBG
11-00004 | 235208 | Service Mains | 235208-Service Mains | 1 | 55145 | 1809 | 55146 | 3641.5 | 92668.46 | 707 | 17096.49 | PBG
11-00004 | 235209 | Waste Water | 235209-Waste Water | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | PBG
11-00004 | 235210 | Heat Recovery Pipe | 235210-Heat Recovery Pipe | 0 | 0 | 0 | 0 | 345.5 | 10702.92 | 0 | 0 | PBG
11-00004 | 235900 | Labor Risk Adj | 235900-Labor Risk Adj | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | PBG
11-00004 | 550000 | Process Piping             PBG | 550000-Process Piping | 687519 | 0 | 22542 | 687519 | 452.5 | 13803.68 | 40 | 1085 | PBG
11-00004 | 551200 | Process Change Order | 551200-Process Change Order | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | PBG
11-00004 | 551300 | Process CR Compressed Air | 551300-Process Compressed Air | 0 | 51606 | 1692 | 51606 | 0 | 0 | 0 | 0 | PBG
11-00004 | 551400 | Process CR Steam | 551400-Process Steam Tracing | 0 | 25711.5 | 843 | 25711.5 | 0 | 0 | 0 | 0 | PBG
11-00004 | 551500 | Process CR Water | 551500-Process Water | 0 | 63318 | 2076 | 63318 | 0 | 0 | 0 | 0 | PBG
11-00004 | 551600 | Process CR Hydrolics | 551600-Process Hydrolics | 0 | 32238.5 | 1057 | 32238.5 | 0 | 0 | 0 | 0 | PBG
11-00004 | 551800 | Process CR Grease | 551800-Process Grease | 0 | 82045 | 2690 | 82045 | 479.5 | 14221.98 | 132 | 3334.8 | PBG
11-00004 | 551900 | Process CR Chemicals | 551900-Process Chemicals | 0 | 9424.5 | 309 | 9424.5 | 0 | 0 | 0 | 0 | PBG
11-00004 | 552000 | Process CR Contingency | 552000-Temp | 0 | 35810.5 | 1174 | 35810.5 | 0 | 0 | 0 | 0 | PBG
 |  | Job
 |  | 11-00004 |  |  | s/b | 52393
 |  | I am sure this is simple and just when I thought I knew what I was doing.
 |  | In the attachment and at the bottom I have a sumifs formula. What I am trying to do is sum based on
 |  | column M, but then have it not sum based on column b for codes 214000, 214001, & 214500. I have the {} and am using an , to separate, but it's ignoring this and giving me the total based on column M.
 |  | Rijlabels | Som van Kolom7
 |  | NO | 3322
 |  | yes | 52393
 |  | Eindtotaal | 55715