Spreadsheet: 145657d1331680364-sumif-type-formula-question-example2012_summer_internship
Sheet: Internships

Summer 2012 Internships |  |  |  |  |  |  |  |  |  | Semester | 2012 Summer
Office | Department | Req | Spots | Dept. Head | Primary Contact | Notes | Status | As Of | Last Active
Atlanta | Urban Touring |  | 1 | [NAME] | [NAME] |  | Cancelled | 2011-09-29 00:00:00 | 2010 Winter |  |  |  | [NAME]
Dallas | Marketing | LIV1729 | 2 | [NAME] | [NAME] |  | Open | 2012-01-18 00:00:00 | 2012 Summer |  |  |  | DallasMarketing
Denver | Marketing | LIV1730 | 6 | [NAME] | [NAME] |  | Open | 2012-01-18 00:00:00 | 2012 Summer |  |  |  | DenverMarketing
Florida | Marketing | LIV1752 | 1 | [NAME] | [NAME] |  | Open | 2012-01-20 00:00:00 | 2012 Summer |  |  |  | FloridaMarketing
[NAME] | Operations | [NAME] | 1 | [NAME] | [NAME] |  | Open | 2012-01-13 00:00:00 | 2012 Summer |  |  |  | KeswickOperations
[NAME] | Retail Sales | LIV1741 | 1 | [NAME] | [NAME] |  | Open | 2012-01-13 00:00:00 | 2012 Summer |  |  |  | KeswickRetail Sales
Los Angeles | CW Marketing | LIV1755 | 1 | [NAME] | [NAME] |  | Open | 2012-01-23 00:00:00 | 2012 Summer |  |  |  | Los AngelesCW Marketing
Los Angeles | El Rey Theatre | LIV1756 | 1 | [NAME] | [NAME] |  | Open | 2012-01-23 00:00:00 | 2012 Summer | GV |  |  | Los AngelesEl Rey Theatre
Los Angeles | Festival Production | LIV1531 | 1 | [NAME] | Leo Nitzberg |  | Cancelled | 2011-09-29 00:00:00 | 2012 Spring | GV |  |  | Los AngelesFestival Production
Los Angeles | Global Partnerships | LIV1731 | 1 | [NAME] | Tyffani Martin |  | Open | 2012-01-18 00:00:00 | 2012 Summer |  |  |  | Los AngelesGlobal Partnerships
Los Angeles | GV Marketing | LIV1732 | 4 | [NAME] | [NAME] |  | Open | 2012-01-18 00:00:00 | 2012 Summer | GV |  |  | Los AngelesGV Marketing
Los Angeles | Interactive Marketing | LIV1733 | 2 | [NAME] | [NAME] |  | Open | 2012-01-18 00:00:00 | 2012 Summer |  |  |  | Los AngelesInteractive Marketing
Los Angeles | Latin Marketing | LIV1734 | 1 | Rebeca Leon | [NAME] |  | Open | 2012-01-18 00:00:00 | 2012 Summer | GV |  |  | Los AngelesLatin Marketing
Los Angeles | Network Live | LIV1757 | 1 | [NAME] | [NAME] |  | Open | 2012-01-23 00:00:00 | 2012 Summer |  |  |  | [NAME]
Los Angeles | Talent Buying | LIV1735 | 1 | [NAME] | [NAME] |  | Open | 2012-01-18 00:00:00 | 2012 Summer | GV |  |  | Los AngelesTalent Buying
Los Angeles | Ticketing |  | 1 | [NAME] | [NAME] |  | Cancelled | 2011-09-29 00:00:00 | 2010 Spring | GV |  |  | Los AngelesTicketing
Los Angeles | Touring |  | 2 | [NAME] | [NAME] |  | Cancelled | 2011-09-29 00:00:00 | 2011 Summer |  |  |  | [NAME]
Midland | Marketing |  | 1 | [NAME] | [NAME] |  | Cancelled | 2011-09-29 00:00:00 | 2011 Spring |  |  |  | MidlandMarketing
Midwest | Marketing |  | 1 | [NAME] | [NAME] |  | Cancelled | 2011-09-29 00:00:00 | 2011 Summer |  |  |  | MidwestMarketing
New York | Production |  | 1 | [NAME] | [NAME] |  | Open | 2012-01-20 00:00:00 | 2012 Summer |  |  |  | New YorkProduction
Philadelphia | Marketing | [NAME] | 1 | [NAME] | [NAME] |  | Open | 2012-01-19 00:00:00 | 2012 Summer |  |  |  | PhiladelphiaMarketing
San Francisco | Marketing | LIV1749 | 1 | [NAME] | [NAME] |  | Open | 2012-01-20 00:00:00 | 2012 Summer |  |  |  | San FranciscoMarketing
San Francisco | Ticketing | [NAME] | 1 | [NAME] | Shane Mealor |  | Open | 2012-01-20 00:00:00 | 2012 Summer |  |  |  | San FranciscoTicketing
Showbox | Special Events & Admin. | LIV1754 | 1 | [NAME] | [NAME] |  | Open | 2012-01-17 00:00:00 | 2012 Summer |  |  |  | ShowboxSpecial Events & Admin.
Showbox | Marketing | [NAME] | 1 | [NAME] | [NAME] |  | Open | 2012-01-18 00:00:00 | 2012 Summer |  |  |  | ShowboxMarketing
Showbox | Production | LIV1680 | 1 | [NAME] | [NAME] |  | Cancelled | 2011-12-21 00:00:00 | 2012 Spring |  |  |  | ShowboxProduction
South Carolina | Marketing | LIV1751 | 1 | [NAME] | [NAME] |  | Open | 2012-01-20 00:00:00 | 2012 Summer |  |  |  | South CarolinaMarketing
TMG Nashville | Marketing | LIV1746 | 1 | [NAME] | [NAME] |  | Open | 2011-09-30 00:00:00 | 2012 Summer | TMG |  |  | TMG NashvilleMarketing