Spreadsheet: 45015d1243817774-if-valuea-appears-in-different-sheet-sum-valueb-with-conditions-mewingexampleforsolving
Sheet: Sheet1

Division | School | StaffID | [NAME] | Role | Student ID | Last Name | Given Name | Status | Program Code | Start | Load
 |  | 000032 |  |  |  |  |  |  |  | 2005-02-04 00:00:00 | 0.5
 |  | 000090 |  |  |  |  |  |  |  | 2009-01-01 00:00:00 | 0.5
 |  | 000145 |  |  |  |  |  |  |  | 2002-03-11 00:00:00 | 0.5
 |  | 000145 |  |  |  |  |  |  |  | 2000-08-08 00:00:00 | 0.5
 |  | 000145 |  |  |  |  |  |  |  | 2005-03-01 00:00:00 | 0.5
 |  | 000145 |  |  |  |  |  |  |  | 2004-01-01 00:00:00 | 0
 |  | 000145 |  |  |  |  |  |  |  | 2006-07-24 00:00:00 | 0.5
 |  | 000381 |  |  |  |  |  |  |  | 2004-08-17 00:00:00 | 0.5
 |  | 000425 |  |  |  |  |  |  |  | 2004-08-09 00:00:00 | 0
 |  | 000425 |  |  |  |  |  |  |  | 2008-01-02 00:00:00 | 1
 |  | 000670 |  |  |  |  |  |  |  | 2002-03-04 00:00:00 | 0.5
 |  | 000790 |  |  |  |  |  |  |  | 2004-03-01 00:00:00 | 1
 |  | 000790 |  |  |  |  |  |  |  | 2006-03-24 00:00:00 | 0
 |  | 000790 |  |  |  |  |  |  |  | 2007-02-19 00:00:00 | 0.5
 |  | 000790 |  |  |  |  |  |  |  | 2004-03-01 00:00:00 | 0.5
 |  | 000790 |  |  |  |  |  |  |  | 2005-08-08 00:00:00 | 1
 |  | 000790 |  |  |  |  |  |  |  | 2007-08-20 00:00:00 | 1
 |  | 000790 |  |  |  |  |  |  |  | 2001-03-01 00:00:00 | 1
 |  | 000790 |  |  |  |  |  |  |  | 2005-07-01 00:00:00 | 1
 |  | 000790 |  |  |  |  |  |  |  | 2006-02-20 00:00:00 | 1
 |  | 000790 |  |  |  |  |  |  |  | 1995-02-28 00:00:00 | 0
 |  | 001095 |  |  |  |  |  |  |  | 2007-07-30 00:00:00 | 1
 |  | 001120 |  |  |  |  |  |  |  | 2006-10-16 00:00:00 | 1
 |  | 001120 |  |  |  |  |  |  |  | 2009-03-30 00:00:00 | 0.5
 |  | 001120 |  |  |  |  |  |  |  | 2009-03-05 00:00:00 | 0.5
 |  | 001120 |  |  |  |  |  |  |  | 2001-03-23 00:00:00 | 0.5
 |  | 001120 |  |  |  |  |  |  |  | 2002-08-19 00:00:00 | 0.5
 |  | 001120 |  |  |  |  |  |  |  | 2007-01-01 00:00:00 | 0.5
 |  | 001120 |  |  |  |  |  |  |  | 1997-02-28 00:00:00 | 0
 |  | 001158 |  |  |  |  |  |  |  | 2009-07-01 00:00:00 | 0
 |  | 001158 |  |  |  |  |  |  |  | 2001-02-26 00:00:00 | 0.5
 |  | 001327 |  |  |  |  |  |  |  | 2002-01-01 00:00:00 | 0.5
 |  | 001327 |  |  |  |  |  |  |  | 1995-03-31 00:00:00 | 0.5
 |  | 001390 |  |  |  |  |  |  |  | 2003-03-11 00:00:00 | 0.5
 |  | 001390 |  |  |  |  |  |  |  | 2006-02-20 00:00:00 | 1
 |  | 001394 |  |  |  |  |  |  |  | 2009-02-16 00:00:00 | 1
 |  | 001394 |  |  |  |  |  |  |  | 2009-02-16 00:00:00 | 1
 |  | 001394 |  |  |  |  |  |  |  | 2009-02-16 00:00:00 | 0.5
 |  | 001394 |  |  |  |  |  |  |  | 2006-07-31 00:00:00 | 1
 |  | 001394 |  |  |  |  |  |  |  | 2005-02-21 00:00:00 | 1
 |  | 001477 |  |  |  |  |  |  |  | 2007-02-19 00:00:00 | 1
 |  | 001810 |  |  |  |  |  |  |  | 2002-01-01 00:00:00 | 0.5
 |  | 001810 |  |  |  |  |  |  |  | 2005-02-28 00:00:00 | 0.5
 |  | 001810 |  |  |  |  |  |  |  | 2006-02-20 00:00:00 | 1
 |  | 001810 |  |  |  |  |  |  |  | 2008-02-18 00:00:00 | 0.5
 |  | 001810 |  |  |  |  |  |  |  | 2008-09-03 00:00:00 | 0.5
 |  | 001890 |  |  |  |  |  |  |  | 2004-03-02 00:00:00 | 0.5
 |  | 001890 |  |  |  |  |  |  |  | 2008-08-04 00:00:00 | 0.5
 |  | 001890 |  |  |  |  |  |  |  | 2009-02-16 00:00:00 | 1
 |  | 002175 |  |  |  |  |  |  |  | 2003-01-01 00:00:00 | 1
 |  | 002234 |  |  |  |  |  |  |  | 2002-02-25 00:00:00 | 0
 |  | 002234 |  |  |  |  |  |  |  | 2008-09-16 00:00:00 | 1
 |  | 002234 |  |  |  |  |  |  |  | 2006-02-27 00:00:00 | 1
 |  | 002234 |  |  |  |  |  |  |  | 2007-07-23 00:00:00 | 1
 |  | 002234 |  |  |  |  |  |  |  | 2008-02-25 00:00:00 | 1
 |  | 002234 |  |  |  |  |  |  |  | 2007-07-23 00:00:00 | 1
 |  | 002312 |  |  |  |  |  |  |  | 2006-08-28 00:00:00 | 0.5
 |  | 002312 |  |  |  |  |  |  |  | 2006-02-20 00:00:00 | 1
 |  | 002338 |  |  |  |  |  |  |  | 2009-01-01 00:00:00 | 0.5
 |  | 002338 |  |  |  |  |  |  |  | 2009-01-01 00:00:00 | 0.5
 |  | 002373 |  |  |  |  |  |  |  | 2007-11-19 00:00:00 | 1
 |  | 002373 |  |  |  |  |  |  |  | 2005-06-30 00:00:00 | 0.5
 |  | 002373 |  |  |  |  |  |  |  | 2008-04-03 00:00:00 | 0.5
 |  | 002591 |  |  |  |  |  |  |  | 2005-02-21 00:00:00 | 0.5
 |  | 004250 |  |  |  |  |  |  |  | 2000-03-29 00:00:00 | 0.5
 |  | 004250 |  |  |  |  |  |  |  | 1998-01-23 00:00:00 | 0.5
 |  | 008290 |  |  |  |  |  |  |  | 2009-02-16 00:00:00 | 1
 |  | 008290 |  |  |  |  |  |  |  | 2009-02-16 00:00:00 | 1
 |  | 008290 |  |  |  |  |  |  |  | 2008-02-18 00:00:00 | 1
 |  | 008290 |  |  |  |  |  |  |  | 2004-01-01 00:00:00 | 0.5
 |  | 009226 |  |  |  |  |  |  |  | 2006-07-17 00:00:00 | 0.5
 |  | 009226 |  |  |  |  |  |  |  | 2007-02-19 00:00:00 | 1
 |  | 009594 |  |  |  |  |  |  |  | 2003-07-28 00:00:00 | 0.5
 |  | 009594 |  |  |  |  |  |  |  | 2005-07-01 00:00:00 | 0.5
 |  | 009594 |  |  |  |  |  |  |  | 1999-03-17 00:00:00 | 0
 |  | 010039 |  |  |  |  |  |  |  | 2007-07-16 00:00:00 | 1
 |  | 010039 |  |  |  |  |  |  |  | 2007-07-16 00:00:00 | 0.5
 |  | 010039 |  |  |  |  |  |  |  | 2004-03-15 00:00:00 | 1
 |  | 010105 |  |  |  |  |  |  |  | 2005-01-10 00:00:00 | 0
 |  | 010275 |  |  |  |  |  |  |  | 2007-03-01 00:00:00 | 1