VBA to sum values in one column based on criteria of another column

[Jim885]

I need someone to help me with this, as I can't figure out how to do it.

The below sample is an accurate example of a much larger set of data that I need help with. Column H will be my desired result.
I need a macro that will look at the matching values (numerical value of month) of Column F, then enter the sum of the corresponding values (rows) contained in Column D for that month. The sum of each month should be placed in Column H at the last value of the row for each particular month.

Thanks to everyone for looking at this.

[TABLE="width: 391"]
<colgroup><col style="width: 27pt; mso-width-source: userset; mso-width-alt: 1316;" width="36"> <col style="width: 48pt;" width="64"> <col style="width: 22pt; mso-width-source: userset; mso-width-alt: 1060;" width="29"> <col style="width: 57pt; mso-width-source: userset; mso-width-alt: 2779;" width="76"> <col style="width: 45pt; mso-width-source: userset; mso-width-alt: 2194;" width="60"> <col style="width: 48pt;" span="4" width="64"> <tbody>[TR]
[TD="class: xl73, width: 36, bgcolor: #BFBFBF"] [/TD]
[TD="class: xl65, width: 64, bgcolor: #BFBFBF"]A[/TD]
[TD="class: xl65, width: 29, bgcolor: #BFBFBF"]B[/TD]
[TD="class: xl65, width: 76, bgcolor: #BFBFBF"]C[/TD]
[TD="class: xl65, width: 60, bgcolor: #BFBFBF"]D[/TD]
[TD="class: xl65, width: 64, bgcolor: #BFBFBF"]E[/TD]
[TD="class: xl65, width: 64, bgcolor: #BFBFBF"]F[/TD]
[TD="class: xl65, width: 64, bgcolor: #BFBFBF"]G[/TD]
[TD="class: xl65, width: 64, bgcolor: #BFBFBF"]H[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: #BFBFBF"]1[/TD]
[TD="class: xl72, bgcolor: transparent"]Item#[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"]Description[/TD]
[TD="class: xl72, bgcolor: transparent"]Quantity[/TD]
[TD="class: xl72, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"]Month[/TD]
[TD="class: xl72, bgcolor: transparent"]Year[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: #BFBFBF"]2[/TD]
[TD="class: xl82, bgcolor: #FCD5B4, align: right"]1001[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: #FCD5B4"]Item 1[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: #BFBFBF"]3[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: #BFBFBF"]4[/TD]
[TD="class: xl67, bgcolor: transparent"]Date[/TD]
[TD="class: xl68, width: 29, bgcolor: transparent"]Transaction Description[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: #BFBFBF"]5[/TD]
[TD="class: xl69, bgcolor: transparent"]5/21/2013[/TD]
[TD="class: xl70, width: 29, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl74, bgcolor: #8DB4E2"]8.00[/TD]
[TD="class: xl75, bgcolor: #8DB4E2"] [/TD]
[TD="class: xl75, bgcolor: #8DB4E2, align: right"]5[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: #BFBFBF"]6[/TD]
[TD="class: xl69, bgcolor: transparent"]5/24/2013[/TD]
[TD="class: xl70, width: 29, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl74, bgcolor: #8DB4E2"]16.00[/TD]
[TD="class: xl75, bgcolor: #8DB4E2"] [/TD]
[TD="class: xl75, bgcolor: #8DB4E2, align: right"]5[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: #BFBFBF"]7[/TD]
[TD="class: xl69, bgcolor: transparent"]5/31/2013[/TD]
[TD="class: xl70, width: 29, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl74, bgcolor: #8DB4E2"]20.00[/TD]
[TD="class: xl75, bgcolor: #8DB4E2"] [/TD]
[TD="class: xl75, bgcolor: #8DB4E2, align: right"]5[/TD]
[TD="class: xl75, bgcolor: #8DB4E2, align: right"]2013[/TD]
[TD="class: xl75, bgcolor: #8DB4E2, align: right"]44[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: #BFBFBF"]8[/TD]
[TD="class: xl69, bgcolor: transparent"]6/1/2013[/TD]
[TD="class: xl70, width: 29, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: #C4BD97"]1.00[/TD]
[TD="class: xl77, bgcolor: #C4BD97"] [/TD]
[TD="class: xl77, bgcolor: #C4BD97, align: right"]6[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: #BFBFBF"]9[/TD]
[TD="class: xl69, bgcolor: transparent"]6/4/2013[/TD]
[TD="class: xl70, width: 29, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: #C4BD97"]2.00[/TD]
[TD="class: xl77, bgcolor: #C4BD97"] [/TD]
[TD="class: xl77, bgcolor: #C4BD97, align: right"]6[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: #BFBFBF"]10[/TD]
[TD="class: xl69, bgcolor: transparent"]6/5/2013[/TD]
[TD="class: xl70, width: 29, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: #C4BD97"]8.00[/TD]
[TD="class: xl77, bgcolor: #C4BD97"] [/TD]
[TD="class: xl77, bgcolor: #C4BD97, align: right"]6[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: #BFBFBF"]11[/TD]
[TD="class: xl69, bgcolor: transparent"]6/6/2013[/TD]
[TD="class: xl70, width: 29, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: #C4BD97"]4.00[/TD]
[TD="class: xl77, bgcolor: #C4BD97"] [/TD]
[TD="class: xl77, bgcolor: #C4BD97, align: right"]6[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: #BFBFBF"]12[/TD]
[TD="class: xl69, bgcolor: transparent"]6/11/2013[/TD]
[TD="class: xl70, width: 29, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: #C4BD97"]4.00[/TD]
[TD="class: xl77, bgcolor: #C4BD97"] [/TD]
[TD="class: xl77, bgcolor: #C4BD97, align: right"]6[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: #BFBFBF"]13[/TD]
[TD="class: xl69, bgcolor: transparent"]6/11/2013[/TD]
[TD="class: xl70, width: 29, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: #C4BD97"]16.00[/TD]
[TD="class: xl77, bgcolor: #C4BD97"] [/TD]
[TD="class: xl77, bgcolor: #C4BD97, align: right"]6[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: #BFBFBF"]14[/TD]
[TD="class: xl69, bgcolor: transparent"]6/14/2013[/TD]
[TD="class: xl70, width: 29, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: #C4BD97"]2.00[/TD]
[TD="class: xl77, bgcolor: #C4BD97"] [/TD]
[TD="class: xl77, bgcolor: #C4BD97, align: right"]6[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: #BFBFBF"]15[/TD]
[TD="class: xl69, bgcolor: transparent"]6/14/2013[/TD]
[TD="class: xl70, width: 29, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: #C4BD97"]2.00[/TD]
[TD="class: xl77, bgcolor: #C4BD97"] [/TD]
[TD="class: xl77, bgcolor: #C4BD97, align: right"]6[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: #BFBFBF"]16[/TD]
[TD="class: xl69, bgcolor: transparent"]6/14/2013[/TD]
[TD="class: xl70, width: 29, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: #C4BD97"]2.00[/TD]
[TD="class: xl77, bgcolor: #C4BD97"] [/TD]
[TD="class: xl77, bgcolor: #C4BD97, align: right"]6[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: #BFBFBF"]17[/TD]
[TD="class: xl69, bgcolor: transparent"]6/24/2013[/TD]
[TD="class: xl70, width: 29, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: #C4BD97"]1.00[/TD]
[TD="class: xl77, bgcolor: #C4BD97"] [/TD]
[TD="class: xl77, bgcolor: #C4BD97, align: right"]6[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: #BFBFBF"]18[/TD]
[TD="class: xl69, bgcolor: transparent"]6/24/2013[/TD]
[TD="class: xl70, width: 29, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: #C4BD97"]4.00[/TD]
[TD="class: xl77, bgcolor: #C4BD97"] [/TD]
[TD="class: xl77, bgcolor: #C4BD97, align: right"]6[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: #BFBFBF"]19[/TD]
[TD="class: xl69, bgcolor: transparent"]6/24/2013[/TD]
[TD="class: xl70, width: 29, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: #C4BD97"]2.00[/TD]
[TD="class: xl77, bgcolor: #C4BD97"] [/TD]
[TD="class: xl77, bgcolor: #C4BD97, align: right"]6[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: #BFBFBF"]20[/TD]
[TD="class: xl69, bgcolor: transparent"]6/25/2013[/TD]
[TD="class: xl70, width: 29, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl76, bgcolor: #C4BD97"]2.00[/TD]
[TD="class: xl77, bgcolor: #C4BD97"] [/TD]
[TD="class: xl77, bgcolor: #C4BD97, align: right"]6[/TD]
[TD="class: xl77, bgcolor: #C4BD97, align: right"]2013[/TD]
[TD="class: xl77, bgcolor: #C4BD97, align: right"]50[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: #BFBFBF"]21[/TD]
[TD="class: xl69, bgcolor: transparent"]7/2/2013[/TD]
[TD="class: xl70, width: 29, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: #B7DEE8"]4.00[/TD]
[TD="class: xl79, bgcolor: #B7DEE8"] [/TD]
[TD="class: xl79, bgcolor: #B7DEE8, align: right"]7[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: #BFBFBF"]22[/TD]
[TD="class: xl69, bgcolor: transparent"]7/2/2013[/TD]
[TD="class: xl70, width: 29, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: #B7DEE8"]1.00[/TD]
[TD="class: xl79, bgcolor: #B7DEE8"] [/TD]
[TD="class: xl79, bgcolor: #B7DEE8, align: right"]7[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: #BFBFBF"]23[/TD]
[TD="class: xl69, bgcolor: transparent"]7/11/2013[/TD]
[TD="class: xl70, width: 29, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: #B7DEE8"]4.00[/TD]
[TD="class: xl79, bgcolor: #B7DEE8"] [/TD]
[TD="class: xl79, bgcolor: #B7DEE8, align: right"]7[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: #BFBFBF"]24[/TD]
[TD="class: xl69, bgcolor: transparent"]7/11/2013[/TD]
[TD="class: xl70, width: 29, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: #B7DEE8"]6.00[/TD]
[TD="class: xl79, bgcolor: #B7DEE8"] [/TD]
[TD="class: xl79, bgcolor: #B7DEE8, align: right"]7[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: #BFBFBF"]25[/TD]
[TD="class: xl69, bgcolor: transparent"]7/16/2013[/TD]
[TD="class: xl70, width: 29, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: #B7DEE8"]5.00[/TD]
[TD="class: xl79, bgcolor: #B7DEE8"] [/TD]
[TD="class: xl79, bgcolor: #B7DEE8, align: right"]7[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: #BFBFBF"]26[/TD]
[TD="class: xl69, bgcolor: transparent"]7/18/2013[/TD]
[TD="class: xl70, width: 29, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: #B7DEE8"]1.00[/TD]
[TD="class: xl79, bgcolor: #B7DEE8"] [/TD]
[TD="class: xl79, bgcolor: #B7DEE8, align: right"]7[/TD]
[TD="class: xl79, bgcolor: #B7DEE8, align: right"]2013[/TD]
[TD="class: xl79, bgcolor: #B7DEE8, align: right"]21[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: #BFBFBF"]27[/TD]
[TD="class: xl69, bgcolor: transparent"]8/20/2013[/TD]
[TD="class: xl70, width: 29, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: #D8E4BC"]1.00[/TD]
[TD="class: xl81, bgcolor: #D8E4BC"] [/TD]
[TD="class: xl81, bgcolor: #D8E4BC, align: right"]8[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: #BFBFBF"]28[/TD]
[TD="class: xl69, bgcolor: transparent"]8/23/2013[/TD]
[TD="class: xl70, width: 29, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: #D8E4BC"]1.00[/TD]
[TD="class: xl81, bgcolor: #D8E4BC"] [/TD]
[TD="class: xl81, bgcolor: #D8E4BC, align: right"]8[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: #BFBFBF"]29[/TD]
[TD="class: xl69, bgcolor: transparent"]8/23/2013[/TD]
[TD="class: xl70, width: 29, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: #D8E4BC"]4.00[/TD]
[TD="class: xl81, bgcolor: #D8E4BC"] [/TD]
[TD="class: xl81, bgcolor: #D8E4BC, align: right"]8[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: #BFBFBF"]30[/TD]
[TD="class: xl69, bgcolor: transparent"]8/26/2013[/TD]
[TD="class: xl70, width: 29, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: #D8E4BC"]2.00[/TD]
[TD="class: xl81, bgcolor: #D8E4BC"] [/TD]
[TD="class: xl81, bgcolor: #D8E4BC, align: right"]8[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: #BFBFBF"]31[/TD]
[TD="class: xl69, bgcolor: transparent"]8/27/2013[/TD]
[TD="class: xl70, width: 29, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: #D8E4BC"]2.00[/TD]
[TD="class: xl81, bgcolor: #D8E4BC"] [/TD]
[TD="class: xl81, bgcolor: #D8E4BC, align: right"]8[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: #BFBFBF"]32[/TD]
[TD="class: xl69, bgcolor: transparent"]8/30/2013[/TD]
[TD="class: xl70, width: 29, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: #D8E4BC"]4.00[/TD]
[TD="class: xl81, bgcolor: #D8E4BC"] [/TD]
[TD="class: xl81, bgcolor: #D8E4BC, align: right"]8[/TD]
[TD="class: xl81, bgcolor: #D8E4BC, align: right"]2013[/TD]
[TD="class: xl81, bgcolor: #D8E4BC, align: right"]14[/TD]
[/TR]
</tbody>[/TABLE]

 

[Marcelo Branco]

Maybe this formula in H5 copied down

=IF(AND(F5=F6,G5=G6),"",SUMIFS($D$5:$D$1000,$F$5:$F$1000,F5,$G$5:$G$1000,G5))

M.

 

[Jim885]

Marcelo,
Thanks for this idea, and it does work. But I need a VBA code for this project. Could you provide that?

 

[Marcelo Branco]

Assuming your data in Sheet1 (adjust if needed) maybe...

Sub aTest()
    Dim lastRow As Long
    
    With Sheets("Sheet1") '<--Adjust sheet name
        lastRow = .Cells(.Rows.Count, "F").End(xlUp).Row
        With .Range("H5:H" & lastRow)
            .Formula = "=IF(AND(F5=F6,G5=G6),"""",SUMIFS($D$5:$D$" & lastRow & _
                ",$F$5:$F$" & lastRow & " ,F5,$G$5:$G$" & lastRow & ",G5))"
            .Value = .Value
        End With
    End With
End Sub

Hope this helps

M.

 

[Jim885]

Marcelo,
Thanks for your effort. There is just one problem that I encounter now that I apply the macro to the whole file.

This file will encompass monthly sums for many item numbers for each month of the year. So, there will be a monthly value (1 ~ 12) in Column F for another item.

As the data runs down the sheet for each item, the monthly values in Column F repeat themselves for each item.

The formula that the macro inputs into each cell in Column H is summing every identical monthly value in that column down to the last row. That captures every monthly value below the subtotal. Thus it adds every instance of each month. Can the formula be adjusted avoid this situation?

 

[Marcelo Branco]

Sorry, I'm not following you.

Are you saying that there are rows with identical pairs month-year and that should be summed separately?

How the formula would distinguish between one set and another? Is there some field that we can use to this purpose?

M.

 

[Marcelo Branco]

Could you provide another data sample where such problem occurs?

M.

 

[Jim885]

Sorry, I'm not following you.

Are you saying that there are rows with identical pairs month-year and that should be summed separately?

How the formula would distinguish between one set and another? Is there some field that we can use to this purpose?

M.

Yes, there are other rows within the columns with identical pairs of months and years. That situation would be a different item number with usages for the same periods (months & year).
The distinguishing factor would be the item number (that is mixed with the dates in Column A), or item description found in Column C.
Another distinguishing factor would be the blocks that are separated by blank rows between each item??

The below sample would be a continuation of the above sample.

[TABLE="width: 359"]
<colgroup><col style="width: 48pt;" width="64"> <col style="width: 28pt; mso-width-source: userset; mso-width-alt: 1353;" width="37"> <col style="width: 46pt; mso-width-source: userset; mso-width-alt: 2230;" width="61"> <col style="width: 45pt; mso-width-source: userset; mso-width-alt: 2194;" width="60"> <col style="width: 48pt;" span="4" width="64"> <tbody>[TR]
[TD="class: xl84, width: 64, bgcolor: #D9D9D9"]A[/TD]
[TD="class: xl85, width: 37, bgcolor: #D9D9D9"]B[/TD]
[TD="class: xl86, width: 61, bgcolor: #D9D9D9"]C[/TD]
[TD="class: xl87, width: 60, bgcolor: #D9D9D9"]D[/TD]
[TD="class: xl86, width: 64, bgcolor: #D9D9D9"]E[/TD]
[TD="class: xl86, width: 64, bgcolor: #D9D9D9"]F[/TD]
[TD="class: xl86, width: 64, bgcolor: #D9D9D9"]G[/TD]
[TD="class: xl86, width: 64, bgcolor: #D9D9D9"]H[/TD]
[/TR]
[TR]
[TD="class: xl79, bgcolor: transparent"]8/23/2013[/TD]
[TD="class: xl80, width: 37, bgcolor: transparent"]TX[/TD]
[TD="class: xl81, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: #D8E4BC"]4.00[/TD]
[TD="class: xl83, bgcolor: #D8E4BC"] [/TD]
[TD="class: xl73, bgcolor: #D8E4BC, align: right"]8[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl81, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]8/26/2013[/TD]
[TD="class: xl71, width: 37, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: #D8E4BC"]2.00[/TD]
[TD="class: xl73, bgcolor: #D8E4BC"] [/TD]
[TD="class: xl73, bgcolor: #D8E4BC, align: right"]8[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]8/27/2013[/TD]
[TD="class: xl71, width: 37, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: #D8E4BC"]2.00[/TD]
[TD="class: xl73, bgcolor: #D8E4BC"] [/TD]
[TD="class: xl73, bgcolor: #D8E4BC, align: right"]8[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]8/30/2013[/TD]
[TD="class: xl71, width: 37, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: #D8E4BC"]4.00[/TD]
[TD="class: xl73, bgcolor: #D8E4BC"] [/TD]
[TD="class: xl73, bgcolor: #D8E4BC, align: right"]8[/TD]
[TD="class: xl73, bgcolor: #D8E4BC, align: right"]2013[/TD]
[TD="class: xl73, bgcolor: #D8E4BC, align: right"]13[/TD]
[/TR]
[TR]
[TD="class: xl74, bgcolor: silver"]10102[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl75, width: 61, bgcolor: silver"]Item 2[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl76, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"]Date[/TD]
[TD="class: xl69, width: 37, bgcolor: transparent"]Trans[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl77, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]4/22/2013[/TD]
[TD="class: xl71, width: 37, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"]5.00[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]5[/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]5/14/2013[/TD]
[TD="class: xl71, width: 37, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"]1.00[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]5[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]6/1/2013[/TD]
[TD="class: xl71, width: 37, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"]1.00[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]6[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]6/5/2013[/TD]
[TD="class: xl71, width: 37, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"]1.00[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]6[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]6/10/2013[/TD]
[TD="class: xl71, width: 37, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"]1.00[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]6[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]6/14/2013[/TD]
[TD="class: xl71, width: 37, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"]2.00[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]6[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]6/24/2013[/TD]
[TD="class: xl71, width: 37, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"]1.00[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]6[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl78, bgcolor: transparent, align: right"]6.00[/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]7/2/2013[/TD]
[TD="class: xl71, width: 37, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"]3.00[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]7[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]7/16/2013[/TD]
[TD="class: xl71, width: 37, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"]5.00[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]7[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]7/18/2013[/TD]
[TD="class: xl71, width: 37, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"]1.00[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]7[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]7/19/2013[/TD]
[TD="class: xl71, width: 37, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"]1.00[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]7[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl78, bgcolor: transparent, align: right"]10.00[/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]8/20/2013[/TD]
[TD="class: xl71, width: 37, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"]1.00[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]8[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]8/22/2013[/TD]
[TD="class: xl71, width: 37, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"]2.00[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]8[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]8/23/2013[/TD]
[TD="class: xl71, width: 37, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"]3.00[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]8[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]8/26/2013[/TD]
[TD="class: xl71, width: 37, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"]2.00[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]8[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]8/27/2013[/TD]
[TD="class: xl71, width: 37, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"]2.00[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]8[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]8/29/2013[/TD]
[TD="class: xl71, width: 37, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"]1.00[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]8[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl78, bgcolor: transparent, align: right"]11.00[/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]9/11/2013[/TD]
[TD="class: xl71, width: 37, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"]1.00[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]9[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]9/11/2013[/TD]
[TD="class: xl71, width: 37, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"]2.00[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]9[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]9/24/2013[/TD]
[TD="class: xl71, width: 37, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"]3.00[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]9[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]9/24/2013[/TD]
[TD="class: xl71, width: 37, bgcolor: transparent"]TX[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"]3.00[/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]9[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]2013[/TD]
[TD="class: xl78, bgcolor: transparent, align: right"]9.00[/TD]
[/TR]
</tbody>[/TABLE]

 

[RadioME]

Hi,

I'm new to the forum (and very new to VBA) but I may have something that will help you as long as the data is in the same order as the one above.

Sub Fixed()

Dim lastrow As Integer
Dim Cumulative As Double
Dim i As Integer
Dim startrow As Integer




lastrow = Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
Cumulative = 0
startrow = 6 'Row where your data starts + 1, so row 5 + 1 in this case


For i = startrow To lastrow + 1
    Cumulative = Cumulative + Range("D" & i - 1).Value
    
    If Range("F" & i) <> Range("F" & i - 1) Then
        Range("F" & i - 1).Offset(, 2).Value = Cumulative
        Cumulative = 0
    End If
Next i


End Sub

 

[Jim885]

You're new to VBA? Are you kidding me? That code is great! It did exactly what I needed.
If you're new to VBA, you're going to be amazing pretty soon. But I think you're amazing already, I have been working on this code all day and got no where.
You must have some other kind of code background, because that code you provided is great.

Thanks very much!

You don't have to take on this next step I need, but while I have your attention, I thought I'd ask.

The next thing I need is to compile this data onto another worksheet where the Item numbers are placed in Column A, the descriptions go into Column B, then the totals for each month would be dropped into the respective columns to the right. The second sheet would have headers for each column. Like this;

[TABLE="width: 799"]
<tbody>[TR]
[TD="class: xl67, width: 36, bgcolor: #D9D9D9"][/TD]
[TD="class: xl67, width: 64, bgcolor: #D9D9D9"]A
[/TD]
[TD="class: xl67, width: 104, bgcolor: #D9D9D9"]B
[/TD]
[TD="class: xl67, width: 64, bgcolor: #D9D9D9"]C
[/TD]
[TD="class: xl67, width: 64, bgcolor: #D9D9D9"]D
[/TD]
[TD="class: xl67, width: 64, bgcolor: #D9D9D9"]E
[/TD]
[TD="class: xl67, width: 64, bgcolor: #D9D9D9"]F
[/TD]
[TD="class: xl67, width: 77, bgcolor: #D9D9D9"]G
[/TD]
[TD="class: xl67, width: 64, bgcolor: #D9D9D9"]H
[/TD]
[TD="class: xl67, width: 72, bgcolor: #D9D9D9"]I
[/TD]
[TD="class: xl67, width: 72, bgcolor: #D9D9D9"]J
[/TD]
[TD="class: xl67, width: 64, bgcolor: #D9D9D9"]K
[/TD]
[TD="class: xl67, width: 64, bgcolor: #D9D9D9"]L
[/TD]
[TD="class: xl67, width: 64, bgcolor: #D9D9D9"]M
[/TD]
[TD="class: xl67, width: 64, bgcolor: #D9D9D9"]N
[/TD]
[TD="class: xl67, width: 64, bgcolor: #D9D9D9"]O
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: #D9D9D9"]1
[/TD]
[TD="class: xl65, bgcolor: transparent"]Item #
[/TD]
[TD="class: xl66, bgcolor: transparent"]Description
[/TD]
[TD="class: xl68, bgcolor: transparent"]May-13
[/TD]
[TD="class: xl68, bgcolor: transparent"]Jun-13
[/TD]
[TD="class: xl68, bgcolor: transparent"]Jul-13
[/TD]
[TD="class: xl68, bgcolor: transparent"]Aug-13
[/TD]
[TD="class: xl68, bgcolor: transparent"]Sep-13
[/TD]
[TD="class: xl68, bgcolor: transparent"]Oct-13
[/TD]
[TD="class: xl68, bgcolor: transparent"]Nov-13
[/TD]
[TD="class: xl68, bgcolor: transparent"]Dec-13
[/TD]
[TD="class: xl68, bgcolor: transparent"]Jan-14
[/TD]
[TD="class: xl68, bgcolor: transparent"]Feb-14
[/TD]
[TD="class: xl68, bgcolor: transparent"]Mar-14
[/TD]
[TD="class: xl68, bgcolor: transparent"]Apr-14
[/TD]
[TD="class: xl68, bgcolor: transparent"]May-14
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: #D9D9D9"]2
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]10101
[/TD]
[TD="class: xl63, bgcolor: transparent"]Item 1
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]44
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]50
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]21
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]14
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]45
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]7
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]19
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]30
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]31
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]36
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]42
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]82
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]16
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: #D9D9D9"]3
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]10102
[/TD]
[TD="class: xl63, bgcolor: transparent"]Item 2
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]6
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]10
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]11
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]9
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]6
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]5
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]2
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]3
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]16
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]14
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]10
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]4
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: #D9D9D9"]4
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]10103
[/TD]
[TD="class: xl63, bgcolor: transparent"]Item 3
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]2
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]7
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]2
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]2
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]6
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]5
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]0
[/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: #D9D9D9"]5
[/TD]
[TD="class: xl64, bgcolor: transparent, align: right"]10104
[/TD]
[TD="class: xl63, bgcolor: transparent"]Item 4
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]2
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]3
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]2
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]4
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]4
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]2
[/TD]
[TD="class: xl63, bgcolor: transparent, align: right"]0
[/TD]
[/TR]
</tbody>[/TABLE]