Sum for multiple date ranges

Status
Not open for further replies.
M

mlibby

New Member
Joined
Jul 2, 2008
Messages
9
<TABLE style="WIDTH: 304pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=405 border=0><TBODY><TR style="HEIGHT: 11.25pt" height=15><TD class=xl66 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; WIDTH: 48pt; BORDER-TOP-COLOR: #ebe9ed; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right width=64 height=15>02/01/09</TD><TD class=xl70 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; WIDTH: 64pt; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right width=85>236.11 </TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; WIDTH: 48pt; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" width=64></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; WIDTH: 48pt; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" width=64></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; WIDTH: 48pt; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" width=64></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; WIDTH: 48pt; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" width=64></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl66 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right height=15>02/02/09</TD><TD class=xl70 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right>472.28 </TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl66 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right height=15>02/03/09</TD><TD class=xl70 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right>708.50 </TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl66 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right height=15>02/04/09</TD><TD class=xl70 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right>944.78 </TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl66 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right height=15>02/05/09</TD><TD class=xl70 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right>1,181.11 </TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl66 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right height=15>02/06/09</TD><TD class=xl70 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right>1,417.50 </TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl66 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right height=15>02/07/09</TD><TD class=xl70 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right>1,653.95 </TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl66 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right height=15>02/08/09</TD><TD class=xl70 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right>1,890.45 </TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl66 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right height=15>02/09/09</TD><TD class=xl70 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right>2,127.01 </TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl66 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right height=15>02/10/09</TD><TD class=xl70 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right>2,363.62 </TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl66 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right height=15>02/11/09</TD><TD class=xl70 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right>2,600.29 </TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl66 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right height=15>02/12/09</TD><TD class=xl70 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right>2,837.02 </TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl66 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right height=15>02/13/09</TD><TD class=xl70 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right>3,073.80 </TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl66 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right height=15>02/14/09</TD><TD class=xl70 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right>3,310.63 </TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right>24,817 </TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed; mso-ignore: colspan" colSpan=3>manual sum for 1st through 14th</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl66 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right height=15>02/15/09</TD><TD class=xl70 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right>3,547.53 </TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl66 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right height=15>02/16/09</TD><TD class=xl70 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right>3,784.47 </TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl66 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right height=15>02/17/09</TD><TD class=xl70 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right>4,021.48 </TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl66 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right height=15>02/18/09</TD><TD class=xl70 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right>4,258.54 </TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl66 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right height=15>02/19/09</TD><TD class=xl70 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right>4,495.66 </TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl66 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right height=15>02/20/09</TD><TD class=xl70 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right>4,732.83 </TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl66 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right height=15>02/21/09</TD><TD class=xl70 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right>4,970.06 </TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl66 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right height=15>02/22/09</TD><TD class=xl70 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right>5,207.34 </TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl66 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right height=15>02/23/09</TD><TD class=xl70 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right>5,444.68 </TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl66 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right height=15>02/24/09</TD><TD class=xl70 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right>5,682.08 </TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl66 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right height=15>02/25/09</TD><TD class=xl70 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right>5,919.53 </TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl66 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right height=15>02/26/09</TD><TD class=xl70 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right>6,157.04 </TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl66 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right height=15>02/27/09</TD><TD class=xl70 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right>6,394.61 </TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl66 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right height=15>02/28/09</TD><TD class=xl70 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right>6,632.23 </TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right>96,065 </TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed; mso-ignore: colspan" colSpan=3>manual sum for month of Feb</TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl66 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right height=15>03/01/09</TD><TD class=xl70 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right>6,869.90 </TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl66 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right height=15>03/02/09</TD><TD class=xl70 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right>7,107.64 </TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl66 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right height=15>03/03/09</TD><TD class=xl70 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right>7,345.43 </TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl66 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right height=15>03/04/09</TD><TD class=xl70 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right>7,583.27 </TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl66 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right height=15>03/05/09</TD><TD class=xl70 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right>7,821.17 </TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl66 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right height=15>03/06/09</TD><TD class=xl70 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right>8,059.13 </TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD></TR><TR style="HEIGHT: 11.25pt" height=15><TD class=xl66 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; HEIGHT: 11.25pt; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right height=15>03/07/09</TD><TD class=xl70 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed" align=right>8,297.15 </TD><TD class=xl65 style="BORDER-LEFT-COLOR: #ebe9ed; BORDER-BOTTOM-COLOR: #ebe9ed; BORDER-TOP-COLOR: #ebe9ed; BACKGROUND-COLOR: transparent; BORDER-RIGHT-COLOR: #ebe9ed"></TD></TR></TBODY></TABLE>

The above data is what my problem looks like. I need a formula that will sum from the 1st day of a month through the last day of a month if the pay date is equal to EOMONTH, and, in conjunction, a formula that will sum from the 15th of a month through the 14th of the following month. Basically, what I have here is a loan that goes on for about 50 years. However, the loan might start on the 1st of the month, the 5th of the month, the 15th, the 17th, any day of the month. Thus, what I need is a formula that will select, on say the 14th of a month, all of the values back until the 15th of the prior month.

Thanks everyone.
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
Sort by date Sort by votes
Try this formula copied down:

Excel Workbook
ABC
101/02/2009236.11 
202/02/2009472.28
303/02/2009708.5
404/02/2009944.78
505/02/20091,181.11
606/02/20091,417.50
707/02/20091,653.95
808/02/20091,890.45
909/02/20092,127.01
1010/02/20092,363.62
1111/02/20092,600.29
1212/02/20092,837.02
1313/02/20093,073.80
1414/02/20093,310.6324,817.05
1515/02/20093,547.53
1616/02/20093,784.47
1717/02/20094,021.48
1818/02/20094,258.54
1919/02/20094,495.66
2020/02/20094,732.83
2121/02/20094,970.06
2222/02/20095,207.34
2323/02/20095,444.68
2424/02/20095,682.08
2525/02/20095,919.53
2626/02/20096,157.04
2727/02/20096,394.61
2828/02/20096,632.2396,065.13
2901/03/20096,869.90
Sheet1 (3)
 
Upvote 0
=if(day(a1)=14,sumif(a:a,"<="&a1,b:b)-sumif(a:a,"<="&date(year(a1),month(a1)-1,14),b:b),
If(month(a1)<>month(a1+1),sumif(a:a,"<="&a1,b:b)-sumif(a:a,"<="&(a28-day(a28)),b:b),""))
 
Upvote 0
Dear Excel Jedi Masters,

Thank you both so much. You're both very close. I should've elaborated a little more on some certain constraints.

Basically, this thing is almost exactly like a credit card. Imagine I'm a bank and new customers open credit cards on whatever date. Each card will have a unique (well, up to 31 uniques) monthly anniversary date.

So, while I know I showed two dates in my previous data sheet, there is only one date needed. Basically, cell A1 will always represent a starting date. So, if cell A1 is 01/17/09, then the first sum to occur will be on 02/16/09, thus effectively summing the daily interest amounts for that statement date.

However, if cell A1 is the last day of a month, the formula needs to (wants to) recognize it is the last day of the month, and thus sum the interest on the last day of the month. For example, if cell A1 is 01/31/09, then the first sum will occur on 02/28/09, which will sum from 02/01/09-02/28/09, the second sum will occur on 03/31/09 which will sum from 03/01/09-03/31/09.

Finally, if cell A1 says 01/30/09, then the monthly anniversary will be the 30th of each month, but, in months with less than 30 days, the formula will pick up the last day of the month and sum. For example, cell A1 says 01/30/09, the first sum will occur on 02/28/09, the second sum will occur on 03/30/09, the third sum on 04/30/09, and so on. This appears to be a specific stipulation that will only occur if the start date is the 29th or 30th.

If the start date is the last day of the month, then the formula will always sum on the last day of a month, if it's on the 30th, it will always sum on the 30th or the last day of the month, if it's on the 29th it will always sum on the 29th or the last day of the month, if it's on the 28th, it will always sum on the 28th day of the month, if it's on the 27th, it will always sum on the 27th day of the month, etc.

Please let me know if this helps. If you need any clarification, just lemme know.

I really appreciate this; you are all saviors!
 
Upvote 0
Sorry guys, in that last paragraph, if the start date is, say, the 20th, then the sum will occur on the 19th of the next month, meaning always on the day before the anniversary date, so as not to count an extra day.
 
Upvote 0
I suspect this is not the easiest way (and maybe isn't even correct), but for the data setup in my previous sample, try this. Note the first formula in column C is in cell C2.

Excel Workbook
ABCD
131/01/2009236.11EOM
201/02/2009472.28 
302/02/2009708.5
403/02/2009944.78
504/02/20091,181.11
605/02/20091,417.50
706/02/20091,653.95
807/02/20091,890.45
908/02/20092,127.01
1009/02/20092,363.62
1110/02/20092,600.29
1211/02/20092,837.02
1312/02/20093,073.80
1413/02/20093,310.63
1514/02/20093,547.53
1615/02/20093,784.47
1716/02/20094,021.48
1817/02/20094,258.54
1918/02/20094,495.66
2019/02/20094,732.83
2120/02/20094,970.06
2221/02/20095,207.34
2322/02/20095,444.68
2423/02/20095,682.08
2524/02/20095,919.53
2625/02/20096,157.04
2726/02/20096,394.61
2827/02/20096,632.23
2928/02/20096,869.90102,698.92
3001/03/20097,107.64
Sum Date Range (2)
 
Upvote 0
Why are you double-posting this same question, and not even referencing that thread or the solutions you received, which worked according to what you said you wanted, for every scenario you presented there.

http://www.mrexcel.com/forum/showthread.php?t=327872

You should continue on with that same thread. Instead, what you are doing here is deceiving the people who are helping, and wasting everyone's time.
 
Last edited:
Upvote 0
Status
Not open for further replies.

Similar threads

G
  • Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
819
gvsumich
G
E
  • Question
Adding a custom message.
Replies
1
Views
426
Micron
M
P
  • Question
Select the time from the list and search with Selenium VBA
Replies
6
Views
212
John_w
J
A
  • Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
1K
Attrazion
A
E
  • Question
Query in excel to Outlook mail take rows with name until next name
Replies
0
Views
348
esben
E

Forum statistics

Threads
1,214,784
Messages
6,121,536
Members
449,037
Latest member
tmmotairi

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top