I am trying to search for the name of a person, and sum the column below between a date range. I can't seem to get any method to work.

think someone could give me a hand please?


Adam J Andrew L Brad D Karl V Kris L Paul L Tim S Yongen W
9/1/2012 OFF 1 VAC OFF OFF 1 OFF off
9/2/2012 1 OFF VAC OFF 1 OFF OFF OFF
9/3/2012 1 STAT VAC STAT 1 STAT STAT STAT
9/4/2012 1 1 VAC 1 1 1 1
9/5/2012 1 1 VAC 1 1 1 1
9/6/2012 OFF 1 VAC 1 1 LIEU 1
9/7/2012 OFF 1 OFF 1 1 1 1
9/8/2012 OFF OFF OFF OFF OFF OFF 1
9/9/2012 OFF OFF OFF OFF OFF OFF OFF
9/10/2012 1 Lieu 1 1 LIEU 1 OFF
9/11/2012 1 Lieu 1 1 LIEU 1 1
9/12/2012 1 Lieu 1 1 LIEU 1 1
9/13/2012 1 Lieu 1 LiEU LIEU 1 1
9/14/2012 1 Lieu 1 LiEU LIEU LIEU 1
9/15/2012 OFF OFF OFF OFF OFF OFF 1
9/16/2012 OFF OFF OFF OFF OFF OFF OFF
9/17/2012 1 1 1 OFF off OFF off