Spreadsheet: 484791d1476444932-need-help-with-an-excel-formula-stumped-book2
Sheet: Sheet1

Week | OTC | ID | Link Type | Work Item Type
WK14 30-06 | 0 | 394544 |  | Task
WK14 30-06 | 0 | 394607 |  | Task
WK14 30-06 | 0 | 388595 |  | Task
WK14 30-06 | 1 | 388597 |  | Task
WK14 30-06 |  | 391630 | Child | Bug
WK14 30-06 | 0 | 380343 |  | Task
WK14 30-06 | 1 | 382600 |  | Task
WK14 30-06 |  | 382949 | Child | Bug
WK14 30-06 | 1 | 382601 |  | Task
WK14 30-06 |  | 382950 | Child | Bug
WK14 30-06 | 1 | 382602 |  | Task
WK14 30-06 |  | 382989 | Child | Bug
WK14 30-06 | 0 | 382605 |  | Task
WK14 30-06 | 1 | 382606 |  | Task
WK14 30-06 |  | 392192 | Child | Bug
WK14 30-06 | 0 | 388610 |  | Task
WK14 30-06 | 0 | 394480 |  | Task
WK14 30-06 | 1 | 354718 |  | Task
WK14 30-06 |  | 389556 | Child | Bug
WK14 30-06 | 0 | 386811 |  | Task
WK14 30-06 | 0 | 392063 |  | Task
WK14 30-06 | 0 | 388508 |  | Task
WK14 30-06 | 0 | 351502 |  | Task
WK14 30-06 | 0 | 364161 |  | Task
WK14 30-06 | 0 | 380999 |  | Task
WK14 30-06 | 0 | 383077 |  | Task
WK14 30-06 | 0 | 383547 |  | Task
WK14 30-06 | 1 | 384781 |  | Task
WK14 30-06 |  | 386794 | Child | Bug
WK14 30-06 | 0 | 386240 |  | Task
WK14 30-06 | 0 | 386792 |  | Task
WK14 30-06 | 1 | 386806 |  | Task
WK14 30-06 |  | 387271 | Child | Bug
WK14 30-06 | 0 | 387791 |  | Task
WK14 30-06 | 1 | 389165 |  | Task
WK14 30-06 |  | 392155 | Child | Bug
WK14 30-06 | 0 | 389196 |  | Task
WK14 30-06 | 0 | 389586 |  | Task
WK14 30-06 | 4 | 389736 |  | Task
WK14 30-06 |  | 391766 | Child | Bug
WK14 30-06 |  | 391763 | Child | Bug
WK14 30-06 |  | 391772 | Child | Bug
WK14 30-06 |  | 391776 | Child | Bug
WK14 30-06 | 0 | 389824 |  | Task
WK14 30-06 | 0 | 392293 |  | Task
WK14 30-06 | 1 | 393250 |  | Task
WK14 30-06 |  | 393401 | Child | Bug
WK14 30-06 | 0 | 393251 |  | Task
WK14 30-06 | 0 | 393252 |  | Task
WK14 30-06 | 0 | 393253 |  | Task
WK14 30-06 | 0 | 393282 |  | Task
WK14 30-06 | 0 | 393684 |  | Task
WK14 30-06 | 0 | 393797 |  | Task
WK14 30-06 | 0 | 394538 |  | Task
WK14 30-06 | 0 | 394539 |  | Task
WK14 30-06 | 1 | 394545 |  | Task
WK14 30-06 |  | 395131 | Child | Bug
WK14 30-06 | 0 | 394547 |  | Task
WK14 30-06 | 0 | 394557 |  | Task
WK14 30-06 | 1 | 394568 |  | Task
WK14 30-06 |  | 395180 | Child | Bug
WK14 30-06 | 0 | 394576 |  | Task
WK14 30-06 | 0 | 394577 |  | Task
WK14 30-06 | 0 | 394597 |  | Task
WK14 30-06 | 0 | 394598 |  | Task
WK14 30-06 | 0 | 394600 |  | Task
WK14 30-06 | 0 | 394601 |  | Task
WK14 30-06 | 0 | 394602 |  | Task
WK14 30-06 | 0 | 394605 |  | Task
WK14 30-06 | 0 | 394609 |  | Task
WK14 30-06 | 0 | 394610 |  | Task
WK14 30-06 | 0 | 394618 |  | Task
WK14 30-06 | 0 | 394619 |  | Task
WK14 30-06 | 0 | 394621 |  | Task
WK14 30-06 | 0 | 394625 |  | Task
WK14 30-06 | 0 | 394626 |  | Task
WK14 30-06 | 0 | 394629 |  | Task
WK14 30-06 | 0 | 393189 |  | Task
WK14 30-06 | 0 | 393190 |  | Task
WK14 30-06 | 0 | 395914 |  | Task
WK14 30-06 | 0 | 387759 |  | Task
WK14 30-06 | 5 | 392300 |  | Task
WK14 30-06 |  | 393741 | Child | Bug
WK14 30-06 |  | 393685 | Child | Bug
WK14 30-06 |  | 393690 | Child | Bug
WK14 30-06 |  | 393399 | Child | Bug
WK14 30-06 |  | 393403 | Child | Bug
WK14 30-06 | 4 | 392307 |  | Task
WK14 30-06 |  | 393687 | Child | Bug
WK14 30-06 |  | 393688 | Child | Bug
WK14 30-06 |  | 393689 | Child | Bug
WK14 30-06 |  | 393691 | Child | Bug
WK14 30-06 | 3 | 392310 |  | Task
WK14 30-06 |  | 393850 | Child | Bug
WK14 30-06 |  | 393738 | Child | Bug
WK14 30-06 |  | 393744 | Child | Bug
WK14 30-06 | 1 | 392311 |  | Task
WK14 30-06 |  | 393878 | Child | Bug
WK14 30-06 | 4 | 392314 |  | Task