Spreadsheet: 123261d1317454088-help-with-sumif-formula-example
Sheet: Line-A

Request No. | Line No. | Pipe |  | From Manhole | To Manhole | Excavation | Bedding | Pipe |  | Gravel | Layer 1 | Layer 2 | Layer 3 | Layer 4 | Layer 5 | Warning Tape | Layer 6 | Layer 7 | As per Drawing |  |  |  | Updates
 |  | [NAME]. | [NAME]. |  |  |  |  | Test | Survey |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Actual | Executed | Remaining
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Executed Qty |  |  | 300 | 82.5 | 82.5 | 0
ELC/EXT/SEW/0209 | Line A | 800 | RCC | SD.MH-A | SD.MH-A1 |  |  |  |  |  |  |  |  |  |  |  |  |  | 61 | 61 |  |  | 400 | 200 | 200 | 0
ELC/EXT/SEW/0209 | "       " | 800 | RCC | SD.MH-A1 | SD.MH-A2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 100 |  |  | 500 | 199.5 | 199.5 | 0
ELC/EXT/SEW/02011 | "       " | 700 | RCC | SD.MH-A2 | SD.MH-A3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 103.5 | 103.5 |  |  | 600 | 200 | 200 | 0
ELC/EXT/STM/106 | "       " | 700 | RCC | SD.MH-A3 | SD.MH-A4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 85.5 | 85.5 |  |  | 700 | 368 | 368 | 0
ELC/EXT/STM/65 | "       " | 700 | RCC | SD.MH-A4 | SD.MH-A5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 83 | 83 |  |  | 800 | 161 | 161 | 0
ELC/EXT/STM/70 | "       " | 700 | RCC | SD.MH-A5 | SD.MH-A6 |  |  |  |  |  |  |  |  |  |  |  |  |  | 96 | 96 |  |  | 900 | 0 | 0 | 0
ELC/EXT/STM/71 | "       " | 600 | RCC | SD.MH-A6 | SD.MH-A7 |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 100 |  |  | 1000 | 85 | 85 | 0
ELC/EXT/STM/79 | "       " | 600 | RCC | SD.MH-A7 | SD.MH-A8 |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 100 |  |  | 1400 | 274.5 | 274.5 | 0
ELC/EXT/STM/90-R1 | "       " | 500 | RCC | SD.MH-A8 | SD.MH-A9 |  |  |  |  |  |  |  |  |  |  |  |  |  | 93.5 | 93.5 |  |  | 1600 | 970 | 321 | 649
ELC/EXT/STM/93 | "       " | 500 | RCC | SD.MH-A9 | SD.MH-A10 |  |  |  |  |  |  |  |  |  |  |  |  |  | 106 | 106 |  |  |  | 1
ELC\EXTSTM\0113 | "       " | 400 | RCC | SD.MH-A10 | SD.MH-A11 |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 100
ELC\EXTSTM\0118 | "       " | 400 | RCC | SD.MH-A11 | SD.MH-A12 |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 100
ELC/EXT/STM/214 | "       " | 300 | UPVC | SD.MH-A12 | SD.MH-A13 |  |  |  |  |  |  |  |  |  |  |  |  |  | 82.5 | 82.5
ELC/EXT./STM/252 | "       " | 1000 | RCC | SD.MH-A | SD.MH-1A |  |  |  |  |  |  |  |  |  |  |  |  |  | 85 | 85
ELC/EXT/STM/226 | "       " | 1400 | RCC | SD.MH-1A | SD.MH-2A |  |  |  |  |  |  |  |  |  |  |  |  |  | 84.5 | 84.5
ELC/EXT/STM/232 | "       " | 1400 | RCC | SD.MH-2A | SD.MH-3A |  |  |  |  |  |  |  |  |  |  |  |  |  | 95 | 95
ELC/EXT./STM/248 | "       " | 1400 | RCC | SD.MH-3A | SD.MH-4A |  |  |  |  |  |  |  |  |  |  |  |  |  | 95 | 95
ELC/EXT./STM/245 Rev-1 | "       " | 1600 | RCC | SD.MH-4A | SD.MH-5A |  |  |  |  |  |  |  |  |  |  |  |  |  | 96 | 96
ELC/EXT/STM/238 | "       " | 1600 | RCC | SD.MH-5A | SD.MH-6A |  |  |  |  |  |  |  |  |  |  |  |  |  | 75 | 75
 | "       " | 1600 | RCC | SD.MH-6A | SD.MH-7A |  |  |  |  |  |  |  |  |  |  |  |  |  | 75
ELC/EXT/STM/227-R1 | "       " | 1600 | RCC | SD.MH-7A | SD.MH-8A |  |  |  |  |  |  |  |  |  |  |  |  |  | 75 | 75
 | "       " | 1600 | RCC | SD.MH-8A | SD.MH-9A |  |  |  |  |  |  |  |  |  |  |  |  |  | 75
ELC/EXT./STM/254 | "       " | 1600 | RCC | SD.MH-9A | SD.MH-10A |  |  |  |  |  |  |  |  |  |  |  |  |  | 75 | 75
 | "       " | 1600 | RCC | SD.MH-10A | SD.MH-11A |  |  |  |  |  |  |  |  |  |  |  |  |  | 75
 | "       " | 1600 | RCC | SD.MH-11A | SD.MH-12A |  |  |  |  |  |  |  |  |  |  |  |  |  | 75
 | "       " | 1600 | RCC | SD.MH-12A | SD.MH-13A |  |  |  |  |  |  |  |  |  |  |  |  |  | 75
 | "       " | 1600 | RCC | SD.MH-13A | SD.MH-14A |  |  |  |  |  |  |  |  |  |  |  |  |  | 75
 | "       " | 1600 | RCC | SD.MH-14A | SD.MH-15A |  |  |  |  |  |  |  |  |  |  |  |  |  | 75
 | "       " | 1600 | RCC | SD.MH-15A | SD.MH-16A |  |  |  |  |  |  |  |  |  |  |  |  |  | 75
 | "       " | 1600 | RCC | SD.MH-16A | SD.MH-17A |  |  |  |  |  |  |  |  |  |  |  |  |  | 49
 | "       " | 1600 | RCC | SD.MH-17A | SD.MH-18A
 | "       " | 1600 | RCC | SD.MH-18A | SD.MH-19A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Length |  | 2540.5