Spreadsheet: 132788d1323934460-sumproduct-and-ifs-issue-sample_sumprod_issue
Sheet: Lookup

Start Date | Period | Ending Date | YTD Weeks | Period Weeks | Branch | District |  |  |  | Periods | Period Weeks
Select a date | Period 1 | 2011-01-30 00:00:00 | 4 | 4 | Select a branch |  |  |  |  | P1 | 4 | 12 | 12
Before 2011 | Period 2 | 2011-02-27 00:00:00 | 8 | 4 | Albuquerque | Houston-San Antonio-Austin-Albuquerque |  |  |  | P2 | 4 | 12 | 15
2011-01-01 00:00:00 | Period 3 | 2011-03-27 00:00:00 | 12 | 4 | Atlanta | Atlanta-Charleston |  |  |  | P3 | 4 | 12
2011-01-02 00:00:00 | Period 4 | 2011-05-01 00:00:00 | 17 | 5 | [NAME] | Houston-San Antonio-Austin-Albuquerque |  |  |  | P4 | 5 | 15
2011-01-03 00:00:00 | Period 5 | 2011-05-29 00:00:00 | 21 | 4 | Birmingham | Birmingham |  |  |  | P5 | 4 | 12
2011-01-04 00:00:00 | Period 6 | 2011-06-26 00:00:00 | 25 | 4 | Boise | Salt Lake City-Boise |  |  |  | P6 | 4 | 12
2011-01-05 00:00:00 | Period 7 | 2011-07-31 00:00:00 | 30 | 5 | Boston | Boston |  |  |  | P7 | 5 | 15
2011-01-06 00:00:00 | Period 8 | 2011-08-28 00:00:00 | 34 | 4 | Buffalo | Buffalo-Utica |  |  |  | P8 | 4 | 12
2011-01-07 00:00:00 | Period 9 | 2011-09-25 00:00:00 | 38 | 4 | Calgary | Calgary-Saskatoon |  |  |  | P9 | 4 | 12
2011-01-08 00:00:00 | Period 10 | 2011-10-30 00:00:00 | 43 | 5 | Cambridge | Cambridge-London |  |  |  | P10 | 5 | 15
2011-01-09 00:00:00 | Period 11 | 2011-11-27 00:00:00 | 47 | 4 | Charleston | Atlanta-Charleston |  |  |  | P11 | 4 | 12
2011-01-10 00:00:00 | Period 12 | 2011-12-31 00:00:00 | 52 | 5 | Chicago | Chicago-Milwaukee |  |  |  | P12 | 5 | 15
2011-01-11 00:00:00 |  |  |  |  | Cincinnati | Cincinnati-Pittsburgh-Cleveland
2011-01-12 00:00:00 |  |  |  |  | Cleveland | Cincinnati-Pittsburgh-Cleveland
2011-01-13 00:00:00 |  |  |  |  | Concord | San Francisco-Concord
2011-01-14 00:00:00 |  |  |  |  | Dallas | Dallas-Shreveport
2011-01-15 00:00:00 |  |  |  |  | Denver | -New Acquisition-
2011-01-16 00:00:00 |  |  |  |  | Des Moines | Omaha-Des Moines-Sioux Falls
2011-01-17 00:00:00 |  |  |  |  | Detroit | Detroit-Grand Rapids
2011-01-18 00:00:00 |  |  |  |  | Edmonton | Edmonton-Winnipeg
2011-01-19 00:00:00 |  |  |  |  | [NAME] | Miami-Fort Myers
2011-01-20 00:00:00 |  |  |  |  | Fresno | Sacramento-Fresno
2011-01-21 00:00:00 |  |  |  |  | Grand Rapids | Detroit-Grand Rapids
2011-01-22 00:00:00 |  |  |  |  | Halifax | Halifax-Moncton
2011-01-23 00:00:00 |  |  |  |  | Hawaii | -New Acquisition-
2011-01-24 00:00:00 |  |  |  |  | Houston | Houston-San Antonio-Austin-Albuquerque
2011-01-25 00:00:00 |  |  |  |  | Indianapolis | Louisville-Indianapolis
2011-01-26 00:00:00 |  |  |  |  | [NAME] | New Orleans-Jackson
2011-01-27 00:00:00 |  |  |  |  | Kelowna | Vancouver-Kelowna
2011-01-28 00:00:00 |  |  |  |  | Knoxville | -New Acquisition-
2011-01-29 00:00:00 |  |  |  |  | London | Cambridge-London
2011-01-30 00:00:00 |  |  |  |  | Long Island | New York-Long Island
2011-01-31 00:00:00 |  |  |  |  | Los Angeles | Los Angeles-North Los Angeles
2011-02-01 00:00:00 |  |  |  |  | Louisville | Louisville-Indianapolis
2011-02-02 00:00:00 |  |  |  |  | Memphis | Nashville-Memphis
2011-02-03 00:00:00 |  |  |  |  | Miami | Miami-Fort Myers
2011-02-04 00:00:00 |  |  |  |  | Milwaukee | Chicago-Milwaukee
2011-02-05 00:00:00 |  |  |  |  | [NAME] | Halifax-Moncton
2011-02-06 00:00:00 |  |  |  |  | Montreal | Montreal-Quebec City
2011-02-07 00:00:00 |  |  |  |  | Nashville | Nashville-Memphis
2011-02-08 00:00:00 |  |  |  |  | New Orleans | New Orleans-Jackson
2011-02-09 00:00:00 |  |  |  |  | New York | New York-Long Island
2011-02-10 00:00:00 |  |  |  |  | Newark | Newark-White Plains
2011-02-11 00:00:00 |  |  |  |  | North Los Angeles | Los Angeles-North Los Angeles
2011-02-12 00:00:00 |  |  |  |  | Oklahoma City | Oklahoma City-Wichita
2011-02-13 00:00:00 |  |  |  |  | Omaha | Omaha-Des Moines-Sioux Falls
2011-02-14 00:00:00 |  |  |  |  | Orlando | Tampa-Orlando
2011-02-15 00:00:00 |  |  |  |  | Ottawa | Ottawa
2011-02-16 00:00:00 |  |  |  |  | Philadelphia | Washington-Philadelphia
2011-02-17 00:00:00 |  |  |  |  | Pittsburgh | Cincinnati-Pittsburgh-Cleveland
2011-02-18 00:00:00 |  |  |  |  | Portland | Portland
2011-02-19 00:00:00 |  |  |  |  | Quebec City | Montreal-Quebec City
2011-02-20 00:00:00 |  |  |  |  | Sacramento | Sacramento-Fresno
2011-02-21 00:00:00 |  |  |  |  | Salt Lake City | Salt Lake City-Boise
2011-02-22 00:00:00 |  |  |  |  | San Antonio | Houston-San Antonio-Austin-Albuquerque
2011-02-23 00:00:00 |  |  |  |  | San Diego | -New Acquisition-
2011-02-24 00:00:00 |  |  |  |  | San Francisco | San Francisco-Concord
2011-02-25 00:00:00 |  |  |  |  | Saskatoon | Calgary-Saskatoon
2011-02-26 00:00:00 |  |  |  |  | Shreveport | Dallas-Shreveport
2011-02-27 00:00:00 |  |  |  |  | [NAME] | Omaha-Des Moines-Sioux Falls
2011-02-28 00:00:00 |  |  |  |  | Tampa | Tampa-Orlando
2011-03-01 00:00:00 |  |  |  |  | Toronto | Toronto
2011-03-02 00:00:00 |  |  |  |  | [NAME] | Buffalo-Utica
2011-03-03 00:00:00 |  |  |  |  | Vancouver | Vancouver-Kelowna
2011-03-04 00:00:00 |  |  |  |  | Washington | Washington-Philadelphia
2011-03-05 00:00:00 |  |  |  |  | White Plains | Newark-White Plains
2011-03-06 00:00:00 |  |  |  |  | Wichita | Oklahoma City-Wichita
2011-03-07 00:00:00 |  |  |  |  | Winnipeg | Edmonton-Winnipeg
2011-03-08 00:00:00
2011-03-09 00:00:00
2011-03-10 00:00:00
2011-03-11 00:00:00
2011-03-12 00:00:00
2011-03-13 00:00:00
2011-03-14 00:00:00
2011-03-15 00:00:00
2011-03-16 00:00:00
2011-03-17 00:00:00
2011-03-18 00:00:00
2011-03-19 00:00:00
2011-03-20 00:00:00
2011-03-21 00:00:00
2011-03-22 00:00:00
2011-03-23 00:00:00
2011-03-24 00:00:00
2011-03-25 00:00:00
2011-03-26 00:00:00
2011-03-27 00:00:00
2011-03-28 00:00:00
2011-03-29 00:00:00
2011-03-30 00:00:00
2011-03-31 00:00:00
2011-04-01 00:00:00
2011-04-02 00:00:00
2011-04-03 00:00:00
2011-04-04 00:00:00
2011-04-05 00:00:00
2011-04-06 00:00:00
2011-04-07 00:00:00
2011-04-08 00:00:00
2011-04-09 00:00:00
2011-04-10 00:00:00
2011-04-11 00:00:00
2011-04-12 00:00:00
2011-04-13 00:00:00
2011-04-14 00:00:00
2011-04-15 00:00:00
2011-04-16 00:00:00
2011-04-17 00:00:00
2011-04-18 00:00:00
2011-04-19 00:00:00
2011-04-20 00:00:00
2011-04-21 00:00:00
2011-04-22 00:00:00
2011-04-23 00:00:00
2011-04-24 00:00:00
2011-04-25 00:00:00
2011-04-26 00:00:00
2011-04-27 00:00:00
2011-04-28 00:00:00
2011-04-29 00:00:00
2011-04-30 00:00:00
2011-05-01 00:00:00
2011-05-02 00:00:00
2011-05-03 00:00:00
2011-05-04 00:00:00
2011-05-05 00:00:00
2011-05-06 00:00:00
2011-05-07 00:00:00
2011-05-08 00:00:00
2011-05-09 00:00:00
2011-05-10 00:00:00
2011-05-11 00:00:00
2011-05-12 00:00:00
2011-05-13 00:00:00
2011-05-14 00:00:00
2011-05-15 00:00:00
2011-05-16 00:00:00
2011-05-17 00:00:00
2011-05-18 00:00:00
2011-05-19 00:00:00
2011-05-20 00:00:00
2011-05-21 00:00:00
2011-05-22 00:00:00
2011-05-23 00:00:00
2011-05-24 00:00:00
2011-05-25 00:00:00
2011-05-26 00:00:00
2011-05-27 00:00:00
2011-05-28 00:00:00
2011-05-29 00:00:00
2011-05-30 00:00:00
2011-05-31 00:00:00
2011-06-01 00:00:00
2011-06-02 00:00:00
2011-06-03 00:00:00
2011-06-04 00:00:00
2011-06-05 00:00:00
2011-06-06 00:00:00
2011-06-07 00:00:00
2011-06-08 00:00:00
2011-06-09 00:00:00
2011-06-10 00:00:00
2011-06-11 00:00:00
2011-06-12 00:00:00
2011-06-13 00:00:00
2011-06-14 00:00:00
2011-06-15 00:00:00
2011-06-16 00:00:00
2011-06-17 00:00:00
2011-06-18 00:00:00
2011-06-19 00:00:00
2011-06-20 00:00:00
2011-06-21 00:00:00
2011-06-22 00:00:00
2011-06-23 00:00:00
2011-06-24 00:00:00
2011-06-25 00:00:00
2011-06-26 00:00:00
2011-06-27 00:00:00
2011-06-28 00:00:00
2011-06-29 00:00:00
2011-06-30 00:00:00
2011-07-01 00:00:00
2011-07-02 00:00:00
2011-07-03 00:00:00
2011-07-04 00:00:00
2011-07-05 00:00:00
2011-07-06 00:00:00
2011-07-07 00:00:00
2011-07-08 00:00:00
2011-07-09 00:00:00
2011-07-10 00:00:00
2011-07-11 00:00:00
2011-07-12 00:00:00
2011-07-13 00:00:00
2011-07-14 00:00:00
2011-07-15 00:00:00
2011-07-16 00:00:00
2011-07-17 00:00:00
2011-07-18 00:00:00
2011-07-19 00:00:00
2011-07-20 00:00:00
2011-07-21 00:00:00
2011-07-22 00:00:00
2011-07-23 00:00:00
2011-07-24 00:00:00
2011-07-25 00:00:00
2011-07-26 00:00:00
2011-07-27 00:00:00
2011-07-28 00:00:00
2011-07-29 00:00:00
2011-07-30 00:00:00
2011-07-31 00:00:00
2011-08-01 00:00:00
2011-08-02 00:00:00
2011-08-03 00:00:00
2011-08-04 00:00:00
2011-08-05 00:00:00
2011-08-06 00:00:00
2011-08-07 00:00:00
2011-08-08 00:00:00
2011-08-09 00:00:00
2011-08-10 00:00:00
2011-08-11 00:00:00
2011-08-12 00:00:00
2011-08-13 00:00:00
2011-08-14 00:00:00
2011-08-15 00:00:00
2011-08-16 00:00:00
2011-08-17 00:00:00
2011-08-18 00:00:00
2011-08-19 00:00:00
2011-08-20 00:00:00
2011-08-21 00:00:00
2011-08-22 00:00:00
2011-08-23 00:00:00
2011-08-24 00:00:00
2011-08-25 00:00:00
2011-08-26 00:00:00
2011-08-27 00:00:00
2011-08-28 00:00:00
2011-08-29 00:00:00
2011-08-30 00:00:00
2011-08-31 00:00:00
2011-09-01 00:00:00
2011-09-02 00:00:00
2011-09-03 00:00:00
2011-09-04 00:00:00
2011-09-05 00:00:00
2011-09-06 00:00:00
2011-09-07 00:00:00
2011-09-08 00:00:00
2011-09-09 00:00:00
2011-09-10 00:00:00
2011-09-11 00:00:00
2011-09-12 00:00:00
2011-09-13 00:00:00
2011-09-14 00:00:00
2011-09-15 00:00:00
2011-09-16 00:00:00
2011-09-17 00:00:00
2011-09-18 00:00:00
2011-09-19 00:00:00
2011-09-20 00:00:00
2011-09-21 00:00:00
2011-09-22 00:00:00
2011-09-23 00:00:00
2011-09-24 00:00:00
2011-09-25 00:00:00
2011-09-26 00:00:00
2011-09-27 00:00:00
2011-09-28 00:00:00
2011-09-29 00:00:00
2011-09-30 00:00:00
2011-10-01 00:00:00
2011-10-02 00:00:00
2011-10-03 00:00:00
2011-10-04 00:00:00
2011-10-05 00:00:00
2011-10-06 00:00:00
2011-10-07 00:00:00
2011-10-08 00:00:00
2011-10-09 00:00:00
2011-10-10 00:00:00
2011-10-11 00:00:00
2011-10-12 00:00:00
2011-10-13 00:00:00
2011-10-14 00:00:00
2011-10-15 00:00:00
2011-10-16 00:00:00
2011-10-17 00:00:00
2011-10-18 00:00:00
2011-10-19 00:00:00
2011-10-20 00:00:00
2011-10-21 00:00:00
2011-10-22 00:00:00
2011-10-23 00:00:00
2011-10-24 00:00:00
2011-10-25 00:00:00
2011-10-26 00:00:00
2011-10-27 00:00:00
2011-10-28 00:00:00
2011-10-29 00:00:00
2011-10-30 00:00:00
2011-10-31 00:00:00
2011-11-01 00:00:00
2011-11-02 00:00:00
2011-11-03 00:00:00
2011-11-04 00:00:00
2011-11-05 00:00:00
2011-11-06 00:00:00
2011-11-07 00:00:00
2011-11-08 00:00:00
2011-11-09 00:00:00
2011-11-10 00:00:00
2011-11-11 00:00:00
2011-11-12 00:00:00
2011-11-13 00:00:00
2011-11-14 00:00:00
2011-11-15 00:00:00
2011-11-16 00:00:00
2011-11-17 00:00:00
2011-11-18 00:00:00
2011-11-19 00:00:00
2011-11-20 00:00:00
2011-11-21 00:00:00
2011-11-22 00:00:00
2011-11-23 00:00:00
2011-11-24 00:00:00
2011-11-25 00:00:00
2011-11-26 00:00:00
2011-11-27 00:00:00
2011-11-28 00:00:00
2011-11-29 00:00:00
2011-11-30 00:00:00
2011-12-01 00:00:00
2011-12-02 00:00:00
2011-12-03 00:00:00
2011-12-04 00:00:00
2011-12-05 00:00:00
2011-12-06 00:00:00
2011-12-07 00:00:00
2011-12-08 00:00:00
2011-12-09 00:00:00
2011-12-10 00:00:00
2011-12-11 00:00:00
2011-12-12 00:00:00
2011-12-13 00:00:00
2011-12-14 00:00:00
2011-12-15 00:00:00
2011-12-16 00:00:00
2011-12-17 00:00:00
2011-12-18 00:00:00
2011-12-19 00:00:00
2011-12-20 00:00:00
2011-12-21 00:00:00
2011-12-22 00:00:00
2011-12-23 00:00:00
2011-12-24 00:00:00
2011-12-25 00:00:00
2011-12-26 00:00:00
2011-12-27 00:00:00
2011-12-28 00:00:00
2011-12-29 00:00:00
2011-12-30 00:00:00
2011-12-31 00:00:00