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 :)
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
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:eek:ffice:eek:ffice" /><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

itsgrady
  • Solved
Update to sum from year and month
Replies
3
Views
211
felixstraube
F
P
  • Question
Summing Data based on a count of prior month data
2
Replies
12
Views
631
KRice
K
F
  • Question
Multiple OR criteria in argument
Replies
2
Views
160
awoohaw
awoohaw
charlesstricklin
  • Solved
Split week's dates by month?
Replies
7
Views
206
rlv01
R
Y
  • Question
How to have a formula auto update based off the number of filled rows.
Replies
0
Views
199
Yaeger38
Y

Forum statistics

Threads
1,214,942
Messages
6,122,366
Members
449,080
Latest member
Armadillos

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