Spreadsheet: 29307d1224215162-sumif-or-sumproduct-book1
Sheet: Sheet1

Budget Code | Affiliate Z | CGID | Circuit Type | Segment Type | [NAME] | Status | Ckt Speed
CIR1 | [NAME] | 2695 | DS3 | Long Haul | VANCO DIRECT USA | Cancelled | 45
CIR1 | Ada Summary
CIR1 | Albany | 2930 | OC12 | [NAME] | VERIZON (MCI) | Live | 622
CIR1 | Albany Summary
CIR1 | Athol | 1788 | [NAME] | Long Haul | VERIZON | Live | 155
CIR1 | Athol Summary
CIR1 | Bakersfield | 1700 | OC12 | Long Haul | TIME WARNER TELECOM | Cancelled | 622
CIR1 | Bakersfield | 2374 | OC12 | Long Haul | TIME WARNER TELECOM | Cancelled | 622
CIR1 | Bakersfield | 2404 | OC12 | Long Haul | GLOBAL TELECOM & TECHNOLOGY AMERICAS | Cancelled | 622
CIR1 | Bakersfield | 2405 | OC12 | Long Haul | GLOBAL TELECOM & TECHNOLOGY AMERICAS | Cancelled | 622
CIR1 | Bakersfield | 2867 | OC48 | Local Loop | TIME WARNER TELECOM | Live | 2488
CIR1 | Bakersfield | 2867 | OC48 | Loop A | TIME WARNER TELECOM | Live |  | [NAME] | SUMPRODUCT(--(B1:B38=I13)+((E1:E38="local loop")+(E1:E38="Long Haul")+(E13:E38="Loop A")+(E1:E38="loop z")),--((G2:G38="live")+(G2:G38="Pending - Cancellation")),H2:H38)
CIR1 | Bakersfield | 2867 | OC48 | X-Conn | CRG West One Wilshire, LLC | Live |  | Athol | SUMPRODUCT(--(B2:[NAME]=I14)+((E2:E39="local loop")+(E2:E39="Long Haul")+(E14:E39="Loop A")+(E2:E39="loop z")),--((G3:G39="live")+(G3:G39="Pending - Cancellation")),H3:H39)
CIR1 | Bakersfield | 2868 | OC48 | Long Haul | GLOBAL TELECOM & TECHNOLOGY AMERICAS | Live | 2488 | Bakersfield | SUMPRODUCT(--((B2:B40="bakersfield")),--((E2:E40="local loop")+(E2:E40="Long Haul")+(E15:E40="Loop A")+(E2:E40="loop z")),--((G3:G40="live")+(G3:G40="Pending - Cancellation")),H3:H40)
CIR1 | Bakersfield | 2868 | OC48 | X-Conn | LEVEL 3 COMM | Live |  | Bangor | SUMPRODUCT(--(B4:B41=I16)+((E4:E41="local loop")+(E4:E41="Long Haul")+(E16:E41="Loop A")+(E4:E41="loop z")),--((G5:G41="live")+(G5:G41="Pending - Cancellation")),H5:H41)
CIR1 | Bakersfield | TBD | OC48 | Long Haul | TBD | 2009 BUDGET ITEM | 2488 | Barstow | [NAME]:B42=I17)+((E5:E42="local loop")+(E5:E42="Long Haul")+(E17:E42="Loop A")+(E5:E42="loop z")),--((G6:G42="live")+(G6:G42="Pending - Cancellation")),H6:H42)
CIR1 | Bakersfield | TBD | OC48 | X-Conn | TBD | 2009 BUDGET ITEM |  | Beaumont | SUMPRODUCT(--(B6:B43=I18)*((E6:E43="local [NAME]:E43="Long Haul")+(E6:E43="Loop A")+(E6:E43="loop z")),--((G6:G43="live")+(G6:G43="Pending - Cancellation")),H7:H43)
CIR1 | Bakersfield | TBD | OC48 | Long Haul | TBD | 2009 BUDGET ITEM | 2488
CIR1 | Bakersfield | TBD | OC48 | X-Conn | TBD | 2009 BUDGET ITEM
CIR1 | Bakersfield Summary | 4976
CIR1 | Bangor | 2662 | ATM DS 3 | Long Haul | FAIRPOINT COMM | Pending - Cancellation | 45
CIR1 | Bangor | 2778 | ATM OC 3 | Long Haul | FAIRPOINT COMM | Live | 155
CIR1 | Bangor Summary
CIR1 | Barstow | 2295 | DS3 | Long Haul | LEVEL 3 (Wiltel) | Live | 45
CIR1 | Barstow | 2538 | [NAME] |  | LEVEL 3 (Wiltel) | Live | 155
CIR1 | Barstow | TBD | [NAME] |  | TBD | Budgeted | 20000
CIR1 | Barstow Summary
CIR1 | Beaumont | 1097 | OC12 | Loop A | TIME WARNER CABLE | Cancelled
CIR1 | Beaumont | 1276 | OC12 | Local Loop | TIME WARNER CABLE | Live | 622
CIR1 | Beaumont | 2446 | OC48 | Long Haul | INTERSTATE FIBERNET, INC | Live | 2488
CIR1 | Beaumont | 2446 | OC48 | Loop A | LEVEL 3 COMM | Pending - Cancellation | 10000
CIR1 | Beaumont | 2447 | OC48 | Long Haul | QWEST | Live | 2488
CIR1 | Beaumont | 2447 | OC48 | Loop A | LEVEL 3 COMM | Cancelled
CIR1 | Beaumont | 2447 | OC48 | X-Conn | LEVEL 3 COMM | Live
CIR1 | Beaumont | TBD | 10GigE | Long Haul | TBD | 2009 BUDGET ITEM | 0
CIR1 | Beaumont | TBD | 10GigE | Long Haul | TBD | 2009 BUDGET ITEM | 0
CIR1 | [NAME]
 |  |  | 15598