need help with macro or formula that will sum cells on the 1st day of the month

lgerick

lgerick

New Member
Joined
Oct 8, 2008
Messages
25
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
Hello,

I'm trying to write a macro or formula that will sum the following
=(D2+B3)-C3
on the first day of the month.
I need this for each month.
Each month will change, so for
October 1 2008 I need it to sum =237+B2-C2
November 1 2008 I need it to sum =(D2+B3)-C3
December 1 2008 I need it to sum =(D3+B4)-C4
January 1 2009 I need it to sum =(D4+B5)-C5
and so on through September of 2009

I am really struggling with this and would so appreciate any help you can give.

Thanking you in advance [and will most definitely thank you again and again]

lgerick :smile:
 
Sort by date Sort by votes
How is your data laid out? You haven't given us to much to work with because the formula you have can just be drug down and the cell references should change to the one you have in the sequence, so I must be missing something?
 
Upvote 0
schielrn said:
How is your data laid out? You haven't given us to much to work with because the formula you have can just be drug down and the cell references should change to the one you have in the sequence, so I must be missing something?
Click to expand...



<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>
Sorry, I should have been clearer.

MONTH is Column A ARRIVED is Column B LEFT is Column C TOTAL is Column D
<o:p></o:p>
OCTOBER is in ROW 2<o:p></o:p>
NOVEMBER IN row 3 <o:p></o:p>
AND SO ON. {see the example below}<o:p></o:p>
<o:p></o:p>
The reason for =237+B2-C2 in cell D2 is the year started with 237 Arrivals<o:p></o:p>
<o:p></o:p>
So 237 plus new arrivals less those leaving in C2 to = D2 Months end totals<o:p></o:p>
<o:p></o:p>
Then on NOVEMBER 1st I would like it to auto sum =(D2+B3)-C3 which is Octobers totals plus Nov.s new arrivals less Nov.'s leaving.<o:p></o:p>
<o:p></o:p>
then DEC. on Dec 1st and so on. <o:p></o:p>
<o:p></o:p>
so that the TOTAL AT MONTH END is not carried down automatically, but only when that month opens. <o:p></o:p>
<o:p></o:p>
<o:p></o:p>
<o:p></o:p>
the amounts in cells B2:B13 and C2:C13 are retrieved automatically from another sheet in the workbook as such. B2 ='OCTOBER 08'!E9.<o:p></o:p>
<o:p></o:p>
hope this makes sense. I am self taught and still learning as I go :-)<o:p></o:p>
<o:p></o:p>
thanks for responding.<o:p></o:p>
<o:p></o:p>
lgerick

<o:p></o:p>

<o:p></o:p>
<TABLE style="WIDTH: 266pt; BORDER-COLLAPSE: collapse; mso-padding-alt: 0in 0in 0in 0in" cellSpacing=0 cellPadding=0 width=355 border=0><TBODY><TR style="HEIGHT: 38.25pt"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: windowtext 0.5pt solid; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 67pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 38.25pt" vAlign=bottom noWrap width=89>
MONTH<o:p></o:p>







​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: windowtext 0.5pt solid; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; WIDTH: 56pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 38.25pt" vAlign=bottom width=75>
Arrived<o:p></o:p>







​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: windowtext 0.5pt solid; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; WIDTH: 68pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 38.25pt" vAlign=bottom width=91>
Left<o:p></o:p>







​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: windowtext 0.5pt solid; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; WIDTH: 75pt; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 38.25pt" vAlign=bottom width=100>
Total at End of Month<o:p></o:p>​





​
</TD></TR><TR style="HEIGHT: 24.75pt; mso-height-source: userset"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 24.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>OCTOBER<o:p></o:p>


​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 24.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap x:num>
6<o:p></o:p>​





​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 24.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap x:num>
7<o:p></o:p>​





​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 24.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap x:num x:fmla="=237+B2-C2">
236<o:p></o:p>​





​
</TD></TR><TR style="HEIGHT: 26.25pt; mso-height-source: userset"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt" vAlign=bottom noWrap>NOVEMBER<o:p></o:p>


​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt" vAlign=bottom noWrap x:num>
0<o:p></o:p>​





​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt" vAlign=bottom noWrap x:num>
0<o:p></o:p>​





​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt" vAlign=bottom noWrap x:num x:fmla="=(D2+B3)-C3">
236<o:p></o:p>​





​
</TD></TR><TR style="HEIGHT: 26.25pt; mso-height-source: userset"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>DECEMBER<o:p></o:p>


​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap x:num>
0<o:p></o:p>​





​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap x:num>
0<o:p></o:p>​





​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap x:num x:fmla="=(D3+B4)-C4">
236<o:p></o:p>​





​
</TD></TR><TR style="HEIGHT: 26.25pt; mso-height-source: userset"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt" vAlign=bottom noWrap>JANUARY<o:p></o:p>


​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt" vAlign=bottom noWrap x:num>
0<o:p></o:p>​





​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt" vAlign=bottom noWrap x:num>
0<o:p></o:p>​





​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt" vAlign=bottom noWrap x:num x:fmla="=(D4+B5)-C5">
236<o:p></o:p>​





​
</TD></TR><TR style="HEIGHT: 26.25pt; mso-height-source: userset"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>FEBRUARY<o:p></o:p>


​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap x:num>
0<o:p></o:p>​





​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap x:num>
0<o:p></o:p>​





​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap x:num x:fmla="=(D5+B6)-C6">
236<o:p></o:p>​





​
</TD></TR><TR style="HEIGHT: 27pt; mso-height-source: userset"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 27pt" vAlign=bottom noWrap>MARCH<o:p></o:p>


​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 27pt" vAlign=bottom noWrap x:num>
0<o:p></o:p>​





​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 27pt" vAlign=bottom noWrap x:num>
0<o:p></o:p>​





​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 27pt" vAlign=bottom noWrap x:num x:fmla="=(D6+B7)-C7">
236<o:p></o:p>​





​
</TD></TR><TR style="HEIGHT: 24.75pt; mso-height-source: userset"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 24.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>APRIL<o:p></o:p>


​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 24.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap x:num>
0<o:p></o:p>​





​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 24.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap x:num>
0<o:p></o:p>​





​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 24.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap x:num x:fmla="=(D7+B8)-C8">
236<o:p></o:p>​





​
</TD></TR><TR style="HEIGHT: 25.5pt; mso-height-source: userset"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 25.5pt" vAlign=bottom noWrap>MAY<o:p></o:p>


​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 25.5pt" vAlign=bottom noWrap x:num>
0<o:p></o:p>​





​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 25.5pt" vAlign=bottom noWrap x:num>
0<o:p></o:p>​





​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 25.5pt" vAlign=bottom noWrap x:num x:fmla="=(D8+B9)-C9">
236<o:p></o:p>​





​
</TD></TR><TR style="HEIGHT: 26.25pt; mso-height-source: userset"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>JUNE<o:p></o:p>


​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap x:num>
0<o:p></o:p>​





​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap x:num>
0<o:p></o:p>​





​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap x:num x:fmla="=(D9+B10)-C10">
236<o:p></o:p>​





​
</TD></TR><TR style="HEIGHT: 25.5pt; mso-height-source: userset"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 25.5pt" vAlign=bottom noWrap>JULY<o:p></o:p>


​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 25.5pt" vAlign=bottom noWrap x:num>
0<o:p></o:p>​





​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 25.5pt" vAlign=bottom noWrap x:num>
0<o:p></o:p>​





​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 25.5pt" vAlign=bottom noWrap x:num x:fmla="=(D10+B11)-C11">
236<o:p></o:p>​





​
</TD></TR><TR style="HEIGHT: 25.5pt; mso-height-source: userset"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 25.5pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>AUGUST<o:p></o:p>


​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 25.5pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap x:num>
0<o:p></o:p>​





​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 25.5pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap x:num>
0<o:p></o:p>​





​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 25.5pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap x:num x:fmla="=(D11+B12)-C12">
236<o:p></o:p>​





​
</TD></TR><TR style="HEIGHT: 26.25pt; mso-height-source: userset"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt" vAlign=bottom noWrap>SEPTEMBER<o:p></o:p>


​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt" vAlign=bottom noWrap x:num>
0<o:p></o:p>​





​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt" vAlign=bottom noWrap x:num>
0<o:p></o:p>​





​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; BACKGROUND: silver; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 26.25pt" vAlign=bottom noWrap x:num x:fmla="=(D12+B13)-C13">
236<o:p></o:p>​





​
</TD></TR><TR style="HEIGHT: 12.75pt"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap><o:p></o:p>


​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: black 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: solid windowtext .5pt" vAlign=bottom noWrap rowSpan=2 x:num x:fmla="=SUM(B2:B13)+237">
243<o:p></o:p>​





​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: black 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: solid windowtext .5pt" vAlign=bottom noWrap rowSpan=2 x:num x:fmla="=SUM(C2:C13)">
7<o:p></o:p>​





​
</TD><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: black 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent; mso-border-left-alt: solid windowtext .5pt" vAlign=bottom noWrap rowSpan=2 x:num x:fmla="=SUM(B14-C14)">
236<o:p></o:p>​





​
</TD></TR><TR style="HEIGHT: 12.75pt"><TD style="BORDER-RIGHT: windowtext 0.5pt solid; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: windowtext 0.5pt solid; PADDING-TOP: 0in; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap>TOTALS<o:p></o:p>


​
</TD></TR><TR style="HEIGHT: 6pt; mso-height-source: userset"><TD style="BORDER-RIGHT: #e0dfe3; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: #e0dfe3; HEIGHT: 6pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap><o:p></o:p>


​
</TD><TD style="BORDER-RIGHT: #e0dfe3; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: #e0dfe3; HEIGHT: 6pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap><o:p></o:p>


​
</TD><TD style="BORDER-RIGHT: #e0dfe3; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: #e0dfe3; HEIGHT: 6pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap><o:p></o:p>


​
</TD><TD style="BORDER-RIGHT: #e0dfe3; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: #e0dfe3; HEIGHT: 6pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap><o:p></o:p>


​
</TD></TR><TR style="HEIGHT: 12.75pt"><TD style="BORDER-RIGHT: #e0dfe3; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap x:num="39730" x:fmla="=TODAY()">
10/9/2008<o:p></o:p>​





​
</TD><TD style="BORDER-RIGHT: #e0dfe3; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap><o:p></o:p>


​
</TD><TD style="BORDER-RIGHT: #e0dfe3; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap><o:p></o:p>


​
</TD><TD style="BORDER-RIGHT: #e0dfe3; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap><o:p></o:p>


​
</TD></TR><TR style="HEIGHT: 13.5pt"><TD style="BORDER-RIGHT: #e0dfe3; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: #e0dfe3; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap><o:p></o:p>


​
</TD><TD style="BORDER-RIGHT: #e0dfe3; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: #e0dfe3; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap><o:p></o:p>


​
</TD><TD style="BORDER-RIGHT: #e0dfe3; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: #e0dfe3; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap><o:p></o:p>


​
</TD><TD style="BORDER-RIGHT: #e0dfe3; PADDING-RIGHT: 0in; BORDER-TOP: #e0dfe3; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: #e0dfe3; PADDING-TOP: 0in; BORDER-BOTTOM: #e0dfe3; HEIGHT: 13.5pt; BACKGROUND-COLOR: transparent" vAlign=bottom noWrap><o:p></o:p>


​
</TD></TR></TBODY></TABLE>​
<o:p></o:p>
<o:p></o:p>
<o:p></o:p>
 
Upvote 0
You must log in or register to reply here.

Similar threads

L
  • Solved
Sums from Tables based on accumulation of hours
Replies
7
Views
222
LeonardH
L
Z
  • Question Question
Sum Values by month from 1st day to last day of each month, and specific date range
Replies
6
Views
729
alansidman
alansidman
charlesstricklin
  • Solved
SUM including monthly amounts and annual divided by 12?
Replies
5
Views
148
charlesstricklin
charlesstricklin
J
  • Solved
3yr Daily CF - Need Cumulative Sum for Each Month (Resetting Monthly)
Replies
3
Views
215
Asbestos_Jen
Asbestos_Jen
K
  • Solved
Conditionally sum fractional cells based on column headings
Replies
5
Views
301
Cubist
Cubist

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