Spreadsheet: 271084d1381817177-help-on-sumif-statement-mai-baltic-leave
Sheet: LeaveData

Name | Status | Date Hired | Years Employed | Vacation Leave | Used Vacation Leave | Remaining Vacation Leave | Family Leave | Used Family Leave | Remaining Family Leave | Column1
Abba | FT | 2010-08-23 00:00:00 |  |  | 5 |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Years Employed as of | 2013-07-01 00:00:00
Abbot | FT | 2013-05-07 00:00:00 |  |  | 0 |  |  | 0
Adtkins | FT | 2011-10-06 00:00:00 |  |  | 4 |  |  | 1
[NAME] | FT | 2011-05-15 00:00:00 |  |  | 3 |  |  | 0
[NAME] | PT | 2012-03-19 00:00:00 |  |  | 0 |  |  | 0
[NAME] | FT | 2009-12-28 00:00:00 |  |  | 4 |  |  | 1
Bergeman | FT | 2012-10-01 00:00:00 |  |  | 0 |  |  | 0
Blake | CN | 2010-08-17 00:00:00 |  |  | 0 |  |  | 0
[NAME] | FT | 2011-03-20 00:00:00 |  |  | 6 |  |  | 3
Borchardt | CN | 2010-07-06 00:00:00 |  |  | 0 |  |  | 0
Captian | FT | 2012-01-08 00:00:00 |  |  | 3 |  |  | 5
[NAME] | PT | 2009-05-04 00:00:00 |  |  | 0 |  |  | 0
Chi | FT | 2011-09-12 00:00:00 |  |  | 3 |  |  | 2
[NAME] | FT | 2012-06-25 00:00:00 |  |  | 3 |  |  | 0
Christain | FT | 2013-01-21 00:00:00 |  |  | 0 |  |  | 0
Clarke | FT | 2013-02-18 00:00:00 |  |  | 0 |  |  | 0
Crawford | PT | 2012-08-20 00:00:00 |  |  | 0 |  |  | 0
Czeller | FT | 2009-06-29 00:00:00 |  |  | 0 |  |  | 0
[NAME] | PT | 2011-09-12 00:00:00 |  |  | 0 |  |  | 0
[NAME] | FT | 2013-03-04 00:00:00 |  |  | 0 |  |  | 0
[NAME] | FT | 2011-09-26 00:00:00 |  |  | 3 |  |  | 2
Dawes | FT | 2013-01-07 00:00:00 |  |  | 0 |  |  | 0
Doering | FT | 2010-12-27 00:00:00 |  |  | 2 |  |  | 0
Dolan | FT | 2009-05-04 00:00:00 |  |  | 0 |  |  | 3
[NAME] | CN | 2009-06-01 00:00:00 |  |  | 0 |  |  | 0
[NAME] | FT | 2011-07-24 00:00:00 |  |  | 1 |  |  | 0
[NAME] | FT | 2012-12-04 00:00:00 |  |  | 0 |  |  | 0
[NAME] | PT | 2011-08-21 00:00:00 |  |  | 0 |  |  | 0
Frase | FT | 2009-04-06 00:00:00 |  |  | 0 |  |  | 3
Fuller | PT | 2010-12-27 00:00:00 |  |  | 0 |  |  | 0
Gere | FT | 2012-05-14 00:00:00 |  |  | 1 |  |  | 4
[NAME] | FT | 2011-11-13 00:00:00 |  |  | 2 |  |  | 0
Green | FT | 2012-07-23 00:00:00 |  |  | 0 |  |  | 0
[NAME] | EX | 2012-09-05 00:00:00 |  |  | 0 |  |  | 0
Hayden | FT | 2010-08-17 00:00:00 |  |  | 7 |  |  | 2
Hennings | FT | 2009-08-12 00:00:00 |  |  | 2 |  |  | 4
Hensel | PT | 2009-08-07 00:00:00 |  |  | 0 |  |  | 0
Hildeberg | FT | 2010-09-14 00:00:00 |  |  | 4 |  |  | 0
Hogan | EX | 2009-04-06 00:00:00 |  |  | 0 |  |  | 0
[NAME] | FT | 2012-07-31 00:00:00 |  |  | 0 |  |  | 0
Isaacs | FT | 2009-08-18 00:00:00 |  |  | 5 |  |  | 3
Jessup | FT | 2012-08-16 00:00:00 |  |  | 0 |  |  | 0
[NAME] | FT | 2013-05-21 00:00:00 |  |  | 0 |  |  | 0
Kaufmann | FT | 2010-07-26 00:00:00 |  |  | 1 |  |  | 1
Knuteson | PT | 2009-04-06 00:00:00 |  |  | 0 |  |  | 0
[NAME] | PT | 2011-04-03 00:00:00 |  |  | 0 |  |  | 0
Lasek | PT | 2013-04-15 00:00:00 |  |  | 0 |  |  | 0
Laszewski | PT | 2010-09-20 00:00:00 |  |  | 0 |  |  | 0
[NAME] | FT | 2011-12-11 00:00:00 |  |  | 4 |  |  | 1
[NAME] | FT | 2012-01-08 00:00:00 |  |  | 2 |  |  | 1
Lei | FT | 2010-11-29 00:00:00 |  |  | 0 |  |  | 0
Mahanez | FT | 2010-05-03 00:00:00 |  |  | 4 |  |  | 2
Menendez | PT | 2012-08-20 00:00:00 |  |  | 0 |  |  | 0
Meyer | PT | 2009-07-13 00:00:00 |  |  | 0 |  |  | 0
[NAME] | FT | 2011-09-12 00:00:00 |  |  | 3 |  |  | 3
[NAME] | FT | 2011-09-12 00:00:00 |  |  | 4 |  |  | 3
Nevers | FT | 2010-11-29 00:00:00 |  |  | 3 |  |  | 2
Nieland | FT | 2012-12-04 00:00:00 |  |  | 0 |  |  | 0
Okanawa | FT | 2009-09-07 00:00:00 |  |  | 7 |  |  | 3
Palmer | FT | 2012-12-26 00:00:00 |  |  | 0 |  |  | 0
[NAME] | PT | 2011-06-26 00:00:00 |  |  | 0 |  |  | 0
Paulson | PT | 2012-07-09 00:00:00 |  |  | 0 |  |  | 0
[NAME] | PT | 2011-12-11 00:00:00 |  |  | 0 |  |  | 0
Phman | FT | 2012-11-12 00:00:00 |  |  | 0 |  |  | 0
Pia | PT | 2012-08-08 00:00:00 |  |  | 0 |  |  | 0
Quinonese | FT | 2013-01-21 00:00:00 |  |  | 0 |  |  | 0
Raab | FT | 2009-05-04 00:00:00 |  |  | 4 |  |  | 2
[NAME] | FT | 2013-05-07 00:00:00 |  |  | 0 |  |  | 0
Ratcliffe | FT | 2009-06-23 00:00:00 |  |  | 1 |  |  | 2
Raulings | PT | 2011-09-04 00:00:00 |  |  | 0 |  |  | 0
Ricard | PT | 2011-03-06 00:00:00 |  |  | 0 |  |  | 0
Roche | FT | 2011-08-21 00:00:00 |  |  | 1 |  |  | 2
Rodriguez | FT | 2012-04-16 00:00:00 |  |  | 2 |  |  | 1
Rosenblum | FT | 2010-10-14 00:00:00 |  |  | 7 |  |  | 1
[NAME] | PT | 2011-08-21 00:00:00 |  |  | 0 |  |  | 0
[NAME] | PT | 2013-03-04 00:00:00 |  |  | 0 |  |  | 0
Sanchez | FT | 2012-04-30 00:00:00 |  |  | 0 |  |  | 2
Santoirre | FT | 2011-08-29 00:00:00 |  |  | 2 |  |  | 2
Schorr | CN | 2009-04-06 00:00:00 |  |  | 0 |  |  | 0
Shapiro | CN | 2011-04-03 00:00:00 |  |  | 0 |  |  | 0
Sidney | CN | 2012-01-17 00:00:00 |  |  | 0 |  |  | 0
Takayma | FT | 2012-04-16 00:00:00 |  |  | 5 |  |  | 2
Tallard | FT | 2011-04-03 00:00:00 |  |  | 4 |  |  | 0
[NAME] | PT | 2009-08-24 00:00:00 |  |  | 0 |  |  | 0
[NAME] | FT | 2013-01-07 00:00:00 |  |  | 0 |  |  | 0
Unlaughten | PT | 2009-07-13 00:00:00 |  |  | 0 |  |  | 0
Vaughn | FT | 2011-04-06 00:00:00 |  |  | 1 |  |  | 3
Veronese | FT | 2012-05-14 00:00:00 |  |  | 5 |  |  | 1
Vos | PT | 2009-07-13 00:00:00 |  |  | 0 |  |  | 0
Walters | FT | 2010-05-31 00:00:00 |  |  | 5 |  |  | 3
Weigstein | FT | 2012-10-29 00:00:00 |  |  | 0 |  |  | 0
Whitman | FT | 2010-08-11 00:00:00 |  |  | 5 |  |  | 0
Whorle | FT | 2013-05-07 00:00:00 |  |  | 0 |  |  | 0
Whyte | FT | 2009-04-13 00:00:00 |  |  | 4 |  |  | 2
[NAME] | PT | 2011-04-17 00:00:00 |  |  | 0 |  |  | 0
Woods | FT | 2013-05-29 00:00:00 |  |  | 0 |  |  | 0
[NAME] | FT | 2010-08-11 00:00:00 |  |  | 6 |  |  | 2
[NAME] | FT | 2011-05-15 00:00:00 |  |  | 7 |  |  | 1
Young | FT | 2011-06-30 00:00:00 |  |  | 5 |  |  | 0
Zellner | FT | 2010-11-04 00:00:00 |  |  | 0 |  |  | 2
Ziegler | FT | 2010-11-29 00:00:00 |  |  | 7 |  |  | 3
[NAME] | FT | 2010-06-28 00:00:00 |  |  | 0 |  |  | 0