Filter and Sum Similar Items

[helpexcel]

I have a spreadsheet with data in columns A:L. All of the data is the same expect for columns H & L. Is there a macro (vlookup and sumproduct take to long to calc) I can use that would basically take the 1st entry and and copy it to a new sheet with the value in column L the sum of all the rows that have the same data in columns A:K (excluding Column H which is irrelevant)?

[TABLE="width: 755"]
<colgroup><col><col><col><col><col><col><col span="6"></colgroup><tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[/TR]
[TR]
[TD]Orange[/TD]
[TD]ABC[/TD]
[TD]DEF[/TD]
[TD]GHI[/TD]
[TD]JKL[/TD]
[TD]MNO[/TD]
[TD]PQR[/TD]
[TD]California[/TD]
[TD]STU[/TD]
[TD]VWX[/TD]
[TD]YZ[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD]Orange[/TD]
[TD]ABC[/TD]
[TD]DEF[/TD]
[TD]GHI[/TD]
[TD]JKL[/TD]
[TD]MNO[/TD]
[TD]PQR[/TD]
[TD]Florida[/TD]
[TD]STU[/TD]
[TD]VWX[/TD]
[TD]YZ[/TD]
[TD="align: right"]150[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Orange[/TD]
[TD]ABC[/TD]
[TD]DEF[/TD]
[TD]GHI[/TD]
[TD]JKL[/TD]
[TD]MNO[/TD]
[TD]PQR[/TD]
[TD][/TD]
[TD]STU[/TD]
[TD]VWX[/TD]
[TD]YZ[/TD]
[TD="align: right"]250[/TD]
[/TR]
</tbody>[/TABLE]

 

[arthurbr]

Have you tried a Pivot Table or Power Pivot ?

 

[helpexcel]

A pivot table will count an item as many times as it appears in the list. I only want it counted once, even if it appears 100 times.